Exercise 2

Construct the following spreadsheet to calculate the profit earned on the three dolls over a three-month period.

1. Calculate the Total sold of the Hamish McAlpine doll.
2. Replicate the formulae to calculate totals for Dai McJock and The Bev dolls.
3. Calculate the Total Cost of the Hamish McAlpine doll (Cost*Total).
4. Replicate the formulae to calculate the total costs for the Dai McJock and The Bev dolls.
5. Calculate the Total Sales of the Hamish McAlpine doll (Selling Price*Total).
6. Replicate the formulae to calculate the total sales for the Dai McJock and The Bev dolls.
7. Calculate the Profit made for each doll (Total Sales - Total Cost).
8. Calculate total number of dolls sold, the total cost for dolls, the total sales and the total profit.
9. Ensure currency cells are formatted to two decimal places.
10. Print a copy.
11. Change the Selling Price for the Hamish McAlpine doll to £19.50 and print a copy.
12. Save the spreadsheet as 'Dolls' and exit.

You can check your answers here.

Contents: Spreadsheets

Skill Check: Spreadsheets