Make your own free website on Tripod.com

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.