Make your own free website on Tripod.com

SPREADSHEET EXERCISE 01


SCENARIO

As an accounting clerk in Hebden PLC you have been asked to set up a spreadsheet on the NIMBUS network showing monthly income and expenditure figures over a year for the company. To achieve this you are to carry out the following steps.

1. Power on your workstation.

2. Boot up and load a spreadsheet package.

3. Enter the following headings across the top of the sheet, one heading to each column, starting in column two:

JANUARY     FEBRUARY     MARCH     APRIL     MAY     JUNE

4. Enter the following titles in the first column, one title to each row, starting in the row below the headings:

INCOME

GOODS OUT

INTEREST

MONTHLY TOTALS

EXPENDITURE

OVERHEADS

WAGES

GOODS IN

MONTHLY TOTALS

5. Note that INCOME and EXPENDITURE are sub-headings and remain aligned left. No data will be entered along these rows. Align other headings in column one to the right:

6. Enter the following figures for INCOME:

  JANUARY FEBRUARY MARCH APRIL MAY JUNE
GOODS OUT 968.56 634.58 910.68 922.39 739.66 964.58
INTEREST 350.10 350.10 350.10 350.20 350.30 350.20

 

(NB Do not worry if the final zeros in some figures are not displayed. You will be shown later how to display these final zeros.)

7. Enter the following figures for OVERHEADS, WAGES and GOODS IN:

JANUARY FEBRUARY MARCH APRIL MAY JUNE
650.50 650.50 650.50 650.50 650.50 650.50
545.50 545.50 545.50 545.50 545.50 545.50
156.60 167.50 155.69 54.50 146.44 134.82

8. Use appropriate formulae to generate MONTHLY TOTALS for INCOME and EXPENDITURE

9. Increase the OVERHEADS in APRIL to 700.50:

10. Change the display to œ (Pound) format:

11. Change all the INTEREST entries to 400.10

12. Enter a final title in column 1 - PROFIT:

13. Align INCOME, EXPENDITURE and PROFIT titles to the left if they are not already left-aligned:

14. Insert blank rows above INCOME, EXPENDITURE and PROFIT

15. Use the relevant formula to generate the PROFIT totals - (INCOME minus EXPENDITURE).

16. Add a title for HALF-YEAR PROFIT and calculate the appropriate figure for this.

17. Is the business making a half-yearly profit?

18. Note down in which months the business is making a profit (if any).

19. Enter your name at the bottom of your spreadsheet.

20. Save and print out your spreadsheet.

21. By substituting different figures for GOODS OUT, work out the minimum GOODS OUT figures required for each month if the business is not to make a loss in any one month. Make a note of these GOODS OUT figures.