<< PREVIOUS   Exercise 1 - Income and Expenditure   NEXT >>

1. Type the following data in your worksheet. Adjust column widths if necessary to make sure data is displayed in full
(Note! the heading INCOME AND EXPENDITURE can be allowed to spill into the next column).

2. Save your work as initialsIncomeExpense.

3. We will calculate the income for January. We will use the formula for (Adding 2 cells together).
    • Click cell B8 and type =B6+B7
    • Press the Enter or Return key on your keyboard (the answer will appear).

    We will calculate the income for the other months. To do this quickly we will use the Auto Fill option.
    • Click cell B8 and drag the Fill handle to cell G8 (the answers will appear).

4. We will calculate the expenses for January. We will use the formula for (Adding a range of cells).
    • Click cell B17 and type =SUM(B11:B16)
    • Press the Enter or Return key on your keyboard (the answer will appear).

    We will calculate the expenses for the other months. To do this quickly we will use the Auto Fill option.
    • Click cell B17 and drag the Fill handle to cell G17 (the answers will appear).

5. Type a new row label called MONTHLY BALANCE in cell A19. We will calculate the balance for January. We will use the formula for (Subtracting one cell from another)
    • Click cell B19 and type: =B8-B17
    • Press the Enter or Return key on your keyboard (the answer will appear).

    We will calculate the balance for the other months. To do this quickly we will use the Auto Fill option.
    • Click cell B19 and drag the Fill handle to cell G19 (the answers will appear).

6. Type a new column label called 6 MONTH TOTAL in cell H3. We will calculate the 6 monthly totals for all income and expenditure. We will use the formula for (Adding a Range of Cells)
    • Click cell H6 and type: =SUM(B6:G6)
    • Press the Enter or Return key on your keyboard (the answer will appear).

    We will calculate the 6 monthly totals for all other income and expenditure.
    To do this quickly we will use the Auto Fill option.
    • Click cell H6 and drag the Fill handle to cell H19 (the answers will appear).

7. We will now add some bold to the cells to make the data stand out.
    • Click row number 1 (this will highlight that row)
    • Click Bold on the Formatting tool bar

    Continue to Bold, rows 3, 5, 7, 9, 16 and 19

8. Save the changes to your spreadsheet.

9. Type your name in cell A24

10. Print your work (follow the instructions for printing in our notes).

11. It would be useful to also have a printout of the formula used. Follow the instructions for Printing Formulas in your notes.

12. We will now make changes to some of the data. Notice the effect of these changes to the Monthly Totals and the 6 Monthly Totals.
    • Your pay goes up to 960 from April
    • You had to pay an extra 15 for telephone bills in January
    • Rent goes up to 425 from March
    • You’ve got a wedding go to in so you spent 120 on clothes in May.

13. Save these changes.