style to the range B4:G5. Move the content of cell H6 to cell G7 and then apply the formatting options described below: a. Merge and center the range G7:K7. b. Apply the fill color Blue, Accent 2, Lighter 60% (6th column, 3rd row of the Theme Colors palette) to the merged range. 8. Use the September label in cell B8 to fill the range C8:M8 with the months of the year. 9. In cell B14, use the SUM function to total the values in the range B9:B13. Use the Fill handle to copy the formula from B14 into the range C14:M14. 10. In January, the hip-hop class is the center’s least attended class, but Stella’s manager hopes to boost attendance so that they can reach their budget goals. Perform a Goal Seek analysis to determine the number of hip-hop class attendees needed in January (F10) to change the value in cell F14 to 400. (Hint: Cell F10 will be the changing cell.) Keep the results of the Goal Seek Analysis as the new value for cell F10. 11. In cell B15, use the keyboard to enter a formula that multiplies the value in cell B9 (the number of students attending the cardio class) by the value in cell C5 (the cost of each cardio class). Use an absolute cell reference to cell C5 and a relative reference to cell B9.