1. Jennifer would like to spruce up the table data. Change the background color of the range A10:H10 to White, Background 1, Darker 5% (1st column, 2nd row of the Theme Colors palette) and then repeat for the range A12:H12.
2. In the range F9:H12, apply the Percentage number format with zero decimal places.
3. Use the Highlight Cells Rules conditional formatting to format cells in the range G9:G12 with a value less than 6% using Light Red Fill with Dark Red Text.
4. For the merged range A17:A23, rotate the cell contents to 0 degrees and then change the indent to 2.
5. Find and replace all instances of the text "Ins" with Insurance, not including any punctuation. (Hint: You should find and replace two instances.)
6. Finally, she needs to format the workbook for printing. Insert a page break to start a new page at row 14.
7. Set the margins to Narrow.
8. Set rows 1 and 2 as print titles.
9. Create a custom footer for the worksheet. In the left footer section, display the current page number using a Header and Footer element. In the center footer section, display the Sheet Name using a Header and Footer element.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed project.