Basic Spreadsheets Project - Birthday Analysis

Overview

1. Create a workbook containing exactly two worksheets. Name the first worksheet "Worksheet1" and the second worksheet "Worksheet2". You need to delete any other worksheets present.
2. Format the worksheets as shown in Figures 1 and 2. You should be able to match the font, styles, borders and colors (or at least come very close).
3. In Worksheet 1, add your own birth date to cell C2. Then use formulas to calculate how long you have been alive in the different units (you need to get today's date from Worksheet2). You may use Excel date functions but all that is required is that the values are calculated in a formula and the answers are correct.
4. Add your birthdate to the following list of birthdates and enter them in column A of Worksheet 2. You may lie about your age if you like. Cell D2 on worksheet2 needs to dynamically determine the date (use the Today() function).
   • 6/25/1974
   • 7/13/1977
   • 3/13/1983
   • 7/16/1969
   • 1/25/1984
   • 9/13/1985
   • 8/3/1984
   • 8/11/1984
   • 2/5/1982
   • 6/2/1983
   • 3/22/1961
   • 12/11/1965
   • 11/21/1985
   • 10/16/1978
   • 7/26/1982
5. In Worksheet2, enter a single formula in cell B2 that can be copied and pasted down column B to return the age (in years, formatted to display 2 decimal places) of each student in the class. The Yearfrac() function may be helpful.
6. Use a formula to calculate the average age (in years) of the class.
7. Using a formula with a reference to your age in Worksheet 1, calculate the difference between your age and the average age of the class.
8. Save your Excel workbook and upload it to the Birthday dropbox.

Figure 1

Figure 2