Assignment #14

  (30 points)

  1. Watch the video Calculate Age   (CC).

  2. Create a Microsoft Excel document similar to the document developed in the video and shown below. (Data). Formulas must be created for those cells highlighted in the red circles. In particular, formulas must be created for: Age, Serve Alchol, AARP Eligible, Age of average employee, Age of youngest employee, Age of oldest employee, Number of employees < 40, Number of employees AARP eligible. Insert your name somewhere in the document. Rename this sheet "Assignment 14A".



  3. Create a new tab in the Microsoft Excel document created in the previous step. Rename this sheet "Assignment 14B". Enter the data as shown in the image below. Create formulas for the information shown in the red circles. In particular, formulas must be created for: Performance, Minimum, Maximum, and Average. Use the IF statement to evaluate performance: If an employee's sales are greater than or equal to 300, label the performance as "Good." Otherwise, label it as "Needs Improvement."



  4. Explore the tutorial Count Unique Values in Excel Using COUNTIF Function. Convince the instructor that you understand the key concepts in this tutorial by including one or more of the following: a summary of the tutorial, modified formulas similar to those covered in the tutorial, details, examples, charts, tips you learned, etc. Add this information (in a separate tab) to the document created in the previous step.

  5. Save your work as "assignment14.xlsx" when you are finished.

  6. 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. Spreadsheet (Assignment 14A) contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. Spreadsheet uses formulas to compute: Age, Serve Alchol, AARP Eligible, Age of average employee, Age of youngest employee, Age of oldest employee, Number of employees < 40, Number of employees AARP eligible. 10 0 5 10 __/10
2. Spreadsheet (Assignment 14B) contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. Spreadsheet uses formulas to compute: Performance, Minimum, Maximum, and Average. 10 0 5 10 __/10
3. Convinced the instructor that you understand the key concepts covered in the tutorial listed in Step #4. 10 0 5 10 __/10
Total points __/30