<< PREVIOUS   Exercise 4 - Wages

1. Type the following data in your worksheet. Adjust column widths if necessary to make sure data is displayed in full.
(Note! the heading STAFF WAGES FOR FEBRUARY 2004 can be allowed to spill into the other columns)

2. Save your work as initialWages.

3. We will calculate the Pay before Tax for Pritesh Patel.
    • Click cell D3 and type: BEFORE TAX

    • 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 Wages before Tax for the others.
    • To do this quickly we will use the Auto Fill option.

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

4. We will calculate the Tax and NI for Pritesh Patel.
    • Click cell E3 and type: TAX & NI. TAX and National Insurance is 30% (Not in real life I might add!)

    • We will use the formula for (Percentages).

    • Click cell E5 and type =D5/100*30
    • Press the Enter or Return key on your keyboard (the answer will appear).

    • We will calculate the TAX and National Insurance for the others.
    • To do this quickly we will use the Auto Fill option.

    • Click cell E5 and drag the Fill handle to cell E9 (the answers will appear).

5. We will calculate the Take home Pay for Pritesh Patel.
    • Click cell F3 and type: PAY

    • We will use the formula for (Subtracting One Cell from Another).

    • Click cell F5 and type =D5-E5
    • Press the Enter or Return key on your keyboard (the answer will appear).

    • We will calculate the Take Home Pay for the others.
    • To do this quickly we will use the Auto Fill option.

    • Click cell F5 and drag the Fill handle to cell F9 (the answers will appear).

6. It would be useful to find out how much you will have to fork out to pay your staff.
    • Click cell A11 and type: TOTAL

    • We will use the formula for (Adding a Range of Cells).

    • Click cell D11 and type =SUM(D5-D9)
    • Press the Enter or Return key on your keyboard (the answer will appear).

    • We will calculate the Total for the other columns.
    • To do this quickly we will use the Auto Fill option.

    • Click cell D11 and drag the Fill handle to cell F11 (the answers will appear).

7. Click Column letter F and Click Currency on the Formatting toolbar.

8. Type your name in cell A13

9. Save changes to your work.

10. Print spreadsheet.

Note! Follow printing instructions and reduce the size of your printout so that it fits on one sheet. Make sure that you also select Landscape in Page Set Up so it also prints sideways.

11. Print Formulas.