Washington
Total
13 In cell C5, enter a formula that references cell D9 in the
8.000
Arizona worksheet so that the total commission amount for Arizona displays in C5. Create a similar formula to enter the total expense allowance for Arizona in cell C6. Create formulas in the range D5: D6 so that the Washington totals display.
14 In E5: E6, use the SUM function to total the Commission
6.000 and Expense Allowance rows. In C7: E7, use the SUM function to calculate Total Compensation for the Arizona, Washington, and Total columns.
15 In cell B5, insert a Column Sparkline for the range 10.000
C5: D5. In cells B6 and B7, insert Column sparklines for