Assignment #21
(10 points)

  1. Watch Video #8 - "Microsoft Excel: Extracting Names" at one of the following URLs:
    http://www.billrosener.com/teaching/videos/office/2013/excel/ - MS Excel 2013
    http://www.billrosener.com/teaching/videos/office/2010/excel/ - MS Excel 2010

  2. Create a Microsoft Excel document similar to the document developed in the video and shown below. When the command button "Extract Names" is pressed the appropriate first and last names must be displayed.



  3. Insert your name somewhere in the document.

  4. Save your work as "assignment21.xlsm" when you are finished. "xlsm" is a Macro-Enabled workbook.

  5. Upload this file to YOUR-CLASS-WEBSITE.   Help



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Document contains column headers and data. Document uses borders and possibly shading to enhance the visual impact. 2 0 1 2 __/2
2. Document contains a command button labeled "Extract Names". When this command button is pressed, Visual Basic code should extract the first and last names from column A and place this information in Columns B and C. 8 0 4 8 __/8
Total points __/10