Assignment #14
(30 points)
- Watch the video
Calculate Age
(CC).
- 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.
- 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.
- Save your work as "assignment14.xlsx" when you are finished.
- Upload this file to YOUR-CLASS-WEBSITE.
Help
|