National Qualifications Online - Core skills

Spreadsheet activity 4

Amending cell data

There are two cells showing the word 'Total'. You will amend one of these cells to avoid confusion.

  1. Click on C12.
  2. Move the cursor to the formula bar at the top where the cell contents are shown.
  3. Click the button when the cursor is at the end of 'Total'. Note that the text cursor now appears.
  4. Press the space bar and add the word 'Cost'.
  5. Click anywhere in the spreadsheet to view the changes.

Some changes are easier than this but can have a greater impact.

The manager decides that the centre can only afford two, not three, treadmills.

  1. Click on B9.
  2. Enter 2 on the keyboard and press the Return key.

This is an activity to try on your computer

Compare cell D9 on the screen and D9 in your printout.