Task A
1. Set up a worksheet as follows:
2. Ensure that columns B and C and cell E1 are formatted to show the date in the format dd/mm/yyyy.
3. In cell F5, enter a formula to display the person’s age. To do this, use the date in cell E1, the birth date in cell B5 and convert the difference between the two into years by dividing by 365.
4. Copy the formula down to cells F6 to F11 making sure that the formula is correct every time. You may need to make use of an absolute cell reference.
5. In cell G5, create a formula which gives the calculated age as a whole number of years only using the =INT formula. Copy this formula to cells G6 to G11.
6. Save the spreadsheet with the name S3Exercise2A
Your worksheet should look like the following:
