Accounting Number Format with two decimal places to the appropriate cells in row 5 and row 9( do not include the percentages).
7 Apply the Comma Style with two decimal places to the
4.000 appropriate cells in rows 6:8( do not include the percentages). Apply the Total cell style to the appropriate cells in the Total row.
8 Click the Washington sheet tab to ungroup the sheets,
10.000 and then insert a new worksheet. Change the sheet name toSummary and then change the Tab Color to Orange, Accent 2. Widen column A to 25.63( 210 pixels), widen columns B: E to 18.75( 155 pixels).
9 Move the Summary sheet so that it is the first sheet in
8.000 the workbook. In cell A1 of the Summary sheet, type Marisol Desserts and Spices and then Merge & Center the title across the range A1: E1. Apply the Title cell style.