National Qualifications Online - Core skills

Editing a spreadsheet activity

This is an activity to try on your computer

You are going to carry out similar tasks on another file: Population Change. Look back in these notes to find out 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 Males: 18
    • Adult Females: 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 the heading '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.