Editing a spreadsheet activity
You are going to carry out similar tasks on another file: Population Change. Look back in these notes to find how to do any task that you may have forgotten.
- Load the file Population Change.
This file records the numbers in different age groups on a remote island in 1995. - The number of minors 10-15 was entered wrongly for 1995.
Enter the correct number, which is 11. - Enter the numbers for the year 2000. They are:
Adult Male: 18 Adult Female: 17 Minors 10-15: 8 Minors<5: 3 - Widen the A column so that all the labels in the column can be seen.
- Choose your own name for the island.
Enter it into cell A1. - Make bold your name for the island and 'Record of Population Change'.
- Enter a formula in B11 that finds the total population of the island in 1995.
Check that your formula is working properly by using a calculator to add the figures. - Enter a formula to find the total population in the year 2000.
- Save the spreadsheet changes.
- Print the spreadsheet.
- Close all windows on the desktop.