1. Power on your workstation and load SPREADSHEET.
2. Enter a title, ACCOUNTS.
3. Below the title enter the headings, starting from column two, one heading to each column:
JAN FEB MAR APR MAY JUN TOTALS
4. Enter a sub-heading, INCOME, in Column one.
5. Enter the following items, starting from the first column and the fourth row.
MAPS
BOOKS
PENS
PAPER
CARDS
INCOME TOTALS
6. Enter the following figures for each item, for each month:
68.56 34.58 10.68 22.39 39.66 64.58
350.50 350.80 360.70 560.53 345.12 444.12
96.74 57.77 30.55 80.49 67.46 43.78
980.50 980.6l 990.70 990.70 990.70 900.79
182.88 185.65 183.22 181.11 162.55 190.88
7. Enter a second sub-heading in the first column.
EXPENDITURE
8. Enter the following items in the first column.
RENT
WAGES
ELECTRICITY
PURCHASES
EXPENDITURE TOTALS
PROFIT
9. Align all column entries, except INCOME, EXPENDITURE and PROFIT, to the right.
10. Enter the following figures.
For monthly rent: 50.40
For monthly wages: 250.40
For monthly electricity: 102.05
For monthly purchases: 500.00
11. Change all figures displays to £ (pound) format.
12. Using a formula, calculate totals for monthly income.
13. Using a formula, calculate individual item half-yearly income totals.
14. Using a formula, calculate monthly expenditure totals.
15. Using a formula, calculate individual item half-yearly expenditure totals.
16. Using a formula, calculate PROFIT (PROFIT = INCOME TOTALS - EXPENDITURE TOTALS)
17. Create grand cross-totals for income, expenditure and profit in the last column of your spreadsheet.
18. Enter your name at the end of your spreadsheet.
19. Save and print out your spreadsheet.
20. Close down the system.