12. Add a worksheet named Gross Margin & COGS, tab color Aqua, Accent 1 (column 5 row 1), with the following rows at the top: title Boutique du Chic, subtitle Gross Margin by Department, followed by a blank row. Apply the Title cell style to the title and the Subtitle cell style to the subtitle. 13. Below the blank row create a table with the following headings (from left to right). Department, Share of Store Sales, Department Sales, Gross Margin Ratio, Gross Margin and Cost of Goods Sold. Set the width of each column to 15. Merge and center ( not Center Across Selection) the title and subtitle so they are centered above all columns of the table. 14. In the Department column, enter the departments in alphabetical order: Apparel Home Dcor, Stationery. Proof the spelling on the sheet and (if AutoSave is not on) save the workbook. 15. Use VLOOKUP functions to look up data in the Dept Margin table and insert the proper percentages for each department in the Share of Store Sales and Gross Margin Ratio columns. Format using the Percent style, no decimal. 16. Using the amount of sales on the Operating Budget sheet (as a cell reference) and the Share of Store Sales percentage, insert a formula to calculate the Department Sales column amounts. 17. Format the data on the Gross Margin & COGS sheet as an Excel table and name it Gross Margin. Apply the Aqua, Table Style Light 19. For each column heading in the table, apply cell style Heading 4, then Themed Cell Style Accent 4. AutoFit the row height, if necessary, to view all text in the column headings. 18. In the Gross Margin table, use structured references (with field names enclosed in brackets) in formulas that calculate the Gross Margin and Cost of Goods Sold for each department. Round each amount (gross margin and cost of goods sold) to the nearest $50. (You may request instructor assistance if you are not sure how to calculate the gross margin and cost of goods sold from the data provided.)