As part of the stock check, the shop wants to know: - How many copies of each CD are in stock (Number)
- The running total of copies ordered (Running Total)
- Total number sold (Sold)
- Total income from the sale of CDs (Sales)
- Total number of CDs in stock
Alistair adds this information to the spreadsheet. | A | B | C | D | E | F | G |
|---|
| 1 | Artist | Title | Price | Number | Running Total | Sold | Sales | | 2 | Hell Zombies | I'm upset! | £14.99 | 2 | 55 | | | | 3 | M-Psink! | I Want U Baby | £13.99 | 5 | 27 | | | | 4 | Bushwacker | Ibiza Chill | £12.99 | 3 | 45 | | | | 5 | The Squires | Dublin Diaries | £9.99 | 1 | 22 | | | | 6 | Mr TNT | Garage Hits | £9.99 | 0 | 12 | | | | 7 | Totals | | | | | | |
There are lots of different formulas that can be used in spreadsheets to calculate or link numerical information, which takes the hard work out of mathematical calculations.
The = sign is always used when entering a formula. You can use masses of different symbols and functions in a spreadsheet. Here are some examples: TABLE OF FORMULAS | Formula | Maths Equivalent | Process |
|---|
| =B3+B4 | 8 + 6 | Addition | | =B3-B4 | 8 - 6 | Subtraction | | =B3*C3 | 8 x 1 | Multiplication | | =B3/C3 | 8 ÷ 1 | Division | | =SUM(B3:B4) | 8 + 6 | Adds contents of cells B3 to B4 | | =B3>B4 | 8 > 6 | Are the cell contents of B3 greater then B4? True or False | | =B4<B3 | 6 > 8 | Are the cell contents of B4 less then B3? True or False | | =AVERAGE(B2:B4) | | Calculates the average of the contents of the cell range B2 to B4 |
To move data around the spreadsheet
you can use the following functions:
- Delete
- Drag and drop
- Copy, Cut and Paste functions
|
Go to the next screen to have a look at working it out. | 
