<< PREVIOUS   Exercise 2 - Sales   NEXT >>

1. Type the following data in your worksheet. Adjust column widths if necessary to make sure data is displayed in full
(Note! the heading INCOME AND EXPENDITURE can be allowed to spill into the next column).

2. Save your work as initialSales.

3. We will calculate the income made from the sales of individual soft drinks.
    • Click cell D3 and type: INCOME

    We will use the formula for (multiplying 2 cells together).

    • Click cell D5 and type =B5*C5
    • Press the Enter or Return key on your keyboard (the answer will appear).

    We will calculate the income for the other drinks. To do this quickly we will use the Auto Fill option.

    • Click cell D5 and drag the Fill handle to cell D8 (the answers will appear).

4. We will calculate the total soft drinks sold and the total income of soft drinks.
    • Click cell A10 and type: TOTAL

    We will use the formula for (Adding a range of cells).

    • Click cell C10 and type =SUM(C5:C8)
    • Press the Enter or Return key on your keyboard (the answer will appear).

    We will calculate the Total income of soft drinks. To do this quickly we will use the Auto Fill option.

    • Click cell C10 and drag the Fill handle to cell D10 (the answers will appear).

5. Click row number 1. Click Bold. Repeat for rows 3, 10. Bold column D.

6. Save the changes to your work.

7. Type your name in cell A13.

8. Print spreadsheet.

9. Print Formulas.