Part A
Open a new workbook
1. Open a new workbook
2. Change the name of the sheet to Hours worked
3. Move to cell A1, enter Weekly hours
4. Move to cell A2, enter Customer
5. Enter Week 1, Week 2, Week 3 in cells B2, C2 and D2 respectively
6. Enter Customer A, Customer B, Customer C, Customer D in cells A3, A4, A5 and A6 respectively.
7. Save the workbook as Exercise 1A
The worksheet should appear as shown below:
Part B
1. Widen column A to allow for the longest entry in column A.
2. Insert a row below Weekly hours to improve the presentation.
3. For Customer A, enter the value 20 for Week 1 (cell B4), copy this value into Week 2 (cell C4) and Week 3 (cell D4).
4. For Customer B, enter the values 15, 12 and 19.
5. For Customer C, enter the values 17, 15 and 10.
6. For Customer D, enter the values 5, 10 and 8.
7. Save the worksheet as Exercise 1B
The worksheet should appear as shown below:
