and change the Tab Color to Light Green , Background 2 .
3 Click the Arizona sheet tab to make it the active sheet ,
10.000 and then group the worksheets . In cell A1 , type Marisol Desserts and Spices and then Merge & Center the text across the range A1 : F1 . Apply the Title cell style . Merge & Center the text in cell A2 across the range A2 : F2 , and then apply the Heading 3 cell style .
4 With the sheets still grouped , in cell D5 calculate the
5.000
Commission for Moreland by multiplying the Sales times the Commission Rate . Copy the formula down through cell D8 .
5 In cell F5 , calculate Total Compensation by summing
5.000 the Commission and Expense Allowance for Moreland . Copy the formula down through the cell F8 .
6 In row 9 , sum the columns for Sales , Commission , 4.000
Expense Allowance , and Total Compensation . Apply the