Editing a spreadsheet

This is an activity to try on your computer

You will need the file Gym Equipment for this exercise.

The Black Ace Fitness Centre needs to update its equipment. This spreadsheet helps the manager to decide what he can or cannot afford to buy.

Double-click on the icon for Gym Equipment.

The computer recognises it as an Excel file. It launches Excel and then loads the data in Gym Equipment into the Excel layout.

Take a printout of this spreadsheet before you make any changes. Use the printer icon on the tool bar at the top or select Print from the File menu. This will help you see the changes that take place as you edit it.

Click on cells with content to discover which five cells hold a formula. Write down the name of the cells and the formula in each.

Hint: Watch the formula bar immediately above the spreadsheet where the name and the contents of a selected cell appear.