Part A
This exercise modifies the spreadsheet constructed in exercise 1.
1. Open the worksheet previously saved in Exercise 1D.
2. Save the worksheet with the new name Exercise 2A.
3. Week 3 for Customer A should be 30, not 20. Change the value in cell D4.
4. Week 1 for Customer C should be 21, not 17. Change the value in cell B6.
5. Week 2 for Customer D should be 13, not 10. Change the value in cell C7.
6. Change all of the text in row 3 to capital letters.
7. Save the worksheet still with the name Exercise 2A.
The worksheet should appear as shown below:
Part B
1. Insert a column after Week 3 and before Average (between columns D and E).
2. Enter the text Week 4 in cell E3.
3. The hours for each customer in week 4 is 9.
4. Enter the formula for the total of Week 4 in cell E9.
5. A new client was taken on in week 4. Insert a row under Customer D, still leaving a blank row before Totals.
6. The new client name is Customer E. Please enter this in Cell A8.
7. For Customer E, enter values of 0 for Week 1, Week 2 and Week 3. Enter the value of 12 for week 4.
8. Insert an average formula in cell F8 to calculate the average for Customer E. Either enter the formula or copy and paste from above.
9. Check the formulas for Totals for each week, making sure that they include the new row.
10. Check the average formulas to make sure that they include Week 4.
11. Save the worksheet as Exercise 2B
The worksheet should appear as shown below:
