| 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.
|
