$11.$ Prepare A$1$:F$1$ for the title text by changing the fill color of the cells in the range A$1$:F$1$ to Red, Accent $2,$ Darker $25\%.$

$12.$ Make the following font changes to the range A$1$:F$1$: set the font color to white, add italics, and set the font size to $14.$

$13.$ Merge and center the cells in the range A$1$:F$1.$

$14.$ Enter the title for this worksheet in the range A$1$:F$1.$ The title should appear on two lines. The first line should read Status Report. The second line should read Sales and Inventory by Item.

$15.$ Increase the height of Row $1$ so the entire title is visible.

$16.$ Format the values in the range C$3$:C$13$ with dollar signs and two decimal places.

$17.$ Format the values in the range E$3$:F$13$ with comma style, zero decimal places.

$18.$ In cell E$14,$ use AutoSum to calculate the sum of the values in the range E$3$:E$13.$

$19.$ In cell F$14,$ use AutoSum to calculate the sum of the values in the range F$3$:F$13.$

$20.$ Apply All Borders to the range A$1$:F$14.$

$21.$ Add a thick bottom border to row $2$; add a thick bottom border to row $13.$

$22.$ Add a thick line border around the perimeter of the range A$1$:F$14.$

$23.$ Insert a new blank worksheet in the workbook $($this will be Sheet$4).$

$24.$ Delete Sheet$3.$

$25.$ Move Sheet$4$ ahead of Sheet$2$ so the order of the worksheets is Sheet$1,$ Sheet$4,$ and Sheet$2.$

$26.$ Rename the Sheet$1$ worksheet tab to $$Status Report.$$

$27.$ Change the orientation of the Status Report worksheet so it prints landscape instead of portrait.

$28.$ Add a header to the Status Report worksheet that shows the date $($needs to update$)$ in the upper left corner and your name in the center.

$29.$ Add a footer to the Status Report worksheet that shows the page number in the lower right corner with the word $$Page$$ before the number.

$30.$ Center the worksheet both horizontally and vertically on the sheet.

$31.$ Check the spelling of the worksheet and make any necessary changes. Save the SC$1$ Sales and Inventory workbook.

$32.$ Submit the SC$1$ Sales and Inventory workbook as directed by your instructor.