Page 173 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

PRACTICE QUESTION 2

1. Create the worksheet shown above and rename it as “2003 BUDGET”

2. Fill in the formulas to add up the expenses for each month. (dark blue area).

3. Fill in the sum for each expense as well (yellow area).

4. Now, fill (right/ down) the formulas to add up the income for each month as well as the total
from each income source (green and light blue areas).

5. Finish off the calculation and subtract the expenses from the income for each month, that is,
the purple cell minus the red cell.

6. Finish off the calculations and subtract the expenses from the income for each month, that is,
the purple cell minus the red cell. This calculation should be located in cell B26 (grey cell).

164 | P a g e