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