Overview
Only complete steps 6,8,9,10,11, and 12
STEPS INSTRUCTIONS POINTS
| 6 | In cell A1, insert the Excel_BU01_GolfCourse.jpg image. Use the Place over Cells feature. Format the picture to Snap to Grid. Resize the picture to fit so the right border is between columns C and D, and the bottom border is between rows 1 and 2. | 5 |
| 7 | Delete column F. Change the width of column E to 2 | 0 |
| 8 | Merge and Center cell range B3:G3. Apply a Thick Bottom Border to the merged range. | 6 |
| 9 | Wrap text in cell range B4:G4. Center align the range, and then apply the Heading 3 cell style. | 6 |
| 10 | Right align cell A3. AutoFit the column width of column A. | 2 |
| 11 | In cell F5, enter a function to total the Putts Per Round. | 5 |
| 12 | In cell G5, enter a formula to determine the average putting score. Average putting score is determined by the total putts and divided by the number of holes golfed. Decrease the decimal to display only 2 decimal places. | 2 |