Part C
1. The average column is no longer needed. Delete column F.
2. The total number of hours for each client are required. Enter Client Total in cell F3.
3. Widen column F so that the text fits within the column.
4. Enter the formula in Cell F4 to total cells B4 to E4.
5. Copy the formula from cell F4 into cells F5, F6, F7 AND F8 to calculate the other totals.
6. Enter Extended in cell G3.
7. Widen column G so that the text fits within the column.
8. Each client total is to be multiplied by 1.5. Enter a formula in cell G4 to give the total for Customer A multiplied by 1.5.
9. Copy the formula from cell G4 into cells G5, G6, G7 and G8 to calculate the other totals.
10. Save the worksheet as Exercise 2C.
The worksheet should appear as shown below:
