National Qualifications Online - Core skills

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.

  1. Load the file Population Change.
    This file records the numbers in different age groups on a remote island in 1995.
  2. The number of minors 10-15 was entered wrongly for 1995.
    Enter the correct number, which is 11.
  3. Enter the numbers for the year 2000. They are:
    Adult Male: 18
    Adult Female: 17
    Minors 10-15: 8
    Minors<5: 3
  4. Widen the A column so that all the labels in the column can be seen.
  5. Choose your own name for the island.
    Enter it into cell A1.
  6. Make bold your name for the island and 'Record of Population Change'.
  7. 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.
  8. Enter a formula to find the total population in the year 2000.
  9. Save the spreadsheet changes.
  10. Print the spreadsheet.
  11. Close all windows on the desktop.