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 .