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