<< PREVIOUS   Exercise 3 - Invoice   NEXT >>

1. Open the file called ‘invoice’ (ask staff for details)

2. Complete the invoice by adding the following data.

    • Add the following data to your Invoice (column B and column F).
    • Adjust column widths if necessary to make sure data is displayed in full.

3. Save your work as initialInvoice

4. We will calculate the Sub Total for this Invoice.
    • Click cell E30 and type: Sub Total

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

    • Click cell F30 and type =SUM(F20:F26)
    • Press the Enter or Return key on your keyboard (the answer will appear).

5. We will calculate the VAT (Value Added Tax) for this Invoice. VAT is currently 17.5%.
    • Click cell E31 and type: VAT

    • We will use the formula for (Percentages).

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

6. We will calculate the Total for this invoice.
    • Click cell E32 and type: Sub Total

    • We will use the formula for (Adding 2 cells together)

    • Click cell F32 and type =F30+F31
    • Press the Enter or Return key on your keyboard (the answer will appear).

7. Highlight all the figures in column F and click the Currency tool on the Formatting toolbar.

8. Click row number 30. Click Bold. Repeat for rows 31, 32. Bold column D.

9. Replace Jenny Peters with your own name.

10. Save changes to your work

11. Print spreadsheet.

12. Print Formulas.