EXCEL WORK

Assignment 5

Submit a workbook called Assignment5.xlsx

When the workbook is first opened, the following is shown to the user:

Initially there are no values displayed in Column D.

The user enters their birth day in cell D3, birth month in D4, and birth year in D5. For example, if the user’s birthday is June 1 2005: 1, 6, and 2005 are entered. Formulas in cells D7, D8, D10, and D12 then compute and display the appropriate values. Do not display anything in D7, D8, D10, and D12 until the user fills in all 3 cells D3, D4, and D5.

EXAMPLE