$14$

Format the range A$13$:H$42$ as a Table with headers, and apply the style White, Table Style Light $18.$ If the style is not available, choose a similar style. Sort the table from $A$ to $Z$ by Item Name, and then filter on the Category column to display only the Cake types.

$15$ Display a Total Row in the table, and then in cell A$43,$ Sum the Quantity in Stock for the Cake

$8$

items. Type this same result in cell B$11.$ Click in the table, and then on the Design tab, remove the total row from the table. Clear the Category filter.

$16$ Merge & Center cell A$1$ across columns A:H and apply the Title cell style. Merge & Center cell

$7$

A$2$ across columns A:H$,$ and apply the Heading $1$ cell style. Change the theme to lon, and then select and AutoFit all the columns.

If the lon theme is not available, click Browse for Themes and navigate to the files you downloaded with this project. Click lon$\_$Theme.thmx and then click Open.

$17$ Set the orientation to Landscape. From the Page Setup dialog box, center the worksheet

$2$

Horizontally, and set row $13$ to repeat at the top of each page.

$18$ Insert a custom footer in the left section with the file name and scale the worksheet so that the

$2$

Width fits to $1$ page.

$19$ Save and close the file, and then submit for grading.