Format your spreadsheet to make it look more professional and easy to read. See an example (taken from ulearnit)

• Your titles and column headers should be bold.
• Titles could also have a slightly bigger font size.
• You could use borders to create a grid around the table (not the titles).
• You could add shading (cell colour) to header rows.
• You could make sure that the cell format is correct (eg text, number, currency – with ‘£’ sign and 2 decimal places, dates as shown).
• The text in each column could align accurately (eg all left-aligned / all centered / all right-aligned).

PRINT SCREEN ANY CANGES YOU HAVE DONE TO THE SAME WORD FILE UNDER THE LAST SCREEN SHOT

Add formulae to calculate the profit/loss for the business. To do this, you should do the following:

1. Add a Total Sales row to the bottom of the Sales table (the sum of the Amount and VAT columns).
2. Add a Total Expenditure row to the bottom of the Expenditure table (the sum of the Amount column).

SCREEN SHOT THAT YOU HAVE ADDED THE TOTALS TO YOUR WORD FILE

SCREEN SHOT EACH ONE OF THESE TASKS NOTING THE DIFFERENCES THEY ARE MAKING TO YOUR TOTALS AS YOU MAKE THE CHANGES

1. The owner of Downloadable Tunes has made a mistake on order number 1001 – the Amount should be £18 (not £15) and the VAT should be £3.15 (not £2.63).

2. Order 1014 has now been paid and needs to be entered into the spreadsheet. You will need to add a new row and make sure that the formulae still work (check they include the new row).

3. Delete order 1006 as the customer has returned the item. You simply need to delete this row.

Deleting a row