What is this section about?
This section will help you learn how to use a spreadsheet. A spreadsheet is one of...
Spreadsheets do the same kind of tasks as calculators. However, spreadsheets can show you the result of more than one...
When a cell is selected, the name of the cell and its contents are shown elsewhere on the spreadsheet.
This area of...
You will need the file Gym Equipment for this exercise.
The Black Ace Fitness Centre needs to update its...
For the following exercises you will need the file Gym Equipment.
Adding data to a cell
Move the pointer...
Adding a row of data
The manager decides to buy two roller glides at £29.95. Add this data in the right...
Deleting a row of data
The manager decides not to buy scales.
Click the pointer in the box marked 10 to the left...
Amending cell data
There are two cells showing the word 'Total'. You will amend one of these cells to avoid...
Watch the animation to see how to add a row of data to an existing spreadsheet.
...
The manager decides not to buy scales. Let's see how this data is removed from the spreadsheet.
...
In the spreadsheet there are two cells showing 'Total'. Play the animation to see how to amend one of these...
You should have discovered by now that cells D6 to D9 contain a formula. The formula is:
Multiply together the...
Let's try entering another formula.
In your copy of the file, you are going to enter into cell D12 a...
You will have noticed that column A is not wide enough for ' Rowing machine'.
You can change column width in...
Changing font and style is also part of formatting a document.
Font is the way the letters and numbers are...
You are going to change the style of the words in cells A1 and A3. First you have to highlight the words that you want...
Now we are going to use the menus for the following tasks.
Saving a file
In your own spreadsheet:
Click on...
You are going to carry out similar tasks on another file: Population Change. Look back in these notes to find how to...
Numbers make a greater impact when they are shown as a chart. AppleWorks can help you to create charts from the...
Load the spreadsheet Population Change
Enlarge the spreadsheet to make room for a chart.
Create a Pie...
