Part C
1. In cell A9, enter Totals
2. Using the =SUM function, enter a formula in cell B9 to total the cells B4 to B7.
3. Copy this formula from cell B9 into C9 and D9 to calculate the other totals
4. Save the worksheet as Exercise 1C
The worksheet should appear as shown below:
Part D
1. In cell E3 enter Average
2. In cell E4, enter a formula to calculate the average of cells B4 to D4 using the =AVERAGE function.
3. Copy the formula from cell E4 to cells E5, E6 and E7 to calculate the other averages.
4. Save your worksheet as Exercise 1D
The final spreadsheet should appear as shown below:
