The Sold , Sales and Totals information
on Alistair's spreadsheet can be calculated
Ìý
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 Ìý
Ìý
Ìý
Ìý
Ìý
Ìý
To calculate the Sales for Hell Zombies you need to know:
No. of CDs Sold x Price = Sales (total income from the sale of CDs
)
To complete this sum you will need to know:
The price of the CD (this is in cell C2)
How many CDs sold (this information will be in cell F2, but you need
to work this out)
If
you are unable to view the Flash movie above, click here for a non-Flash
alternative.
If
you are unable to view the Flash movie above, click here for a non-Flash
alternative.
There is a simple way of copying the formula into the other Sales cells
without having to type it in 4 times. You can drag the formula down by
using the handle on the bottom right hand corner of the cell:
If
you are unable to view the Flash movie above, click here for a non-Flash
alternative.
Go to the next screen to have a look at updating the information.
