If
you are unable to view the Flash movie above, click here for a non-Flash
alternative.
To save time copying out this formula another three times into each of the other 'Stock' cells, you can simply drag the formula down across the other three Stock cells using the handle (little black box) at the bottom right hand corner of the cell.
| Ìý |
A |
B |
C |
D |
E |
F |
|---|
| 1 |
Supplier |
Price £ |
No. of Videos |
No. of DVDs |
Stock |
Cost |
|---|
| 2 |
Paramount |
2.99 |
20 |
30 |
50 |
Ìý |
|---|
| 3 |
Universal |
2.50 |
35 |
20 |
55 |
Ìý |
|---|
| 4 |
Buena Vista |
3.99 |
45 |
25 |
70 |
Ìý |
|---|
| 5 |
New Line |
1.99 |
50 |
35 |
85 |
Ìý |
|---|
| 6 |
Total |
Ìý |
Ìý |
Ìý |
Ìý |
Ìý |
|---|
Using more formulae, Anita can calculate the cost of stock from an individual supplier, the total number of videos, DVDs and the total cost of all the stock in the video store.
|
