In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26. In cell B5, enter a formula to calculate the average annual sales for all sales associates. Use the named range AnnualSales. In cell C5, enter a formula to calculate the median annual sales for all sales associates. Use the named range AnnualSales. In cell D5, enter a formula to calculate the standard deviation for sales. This dataset is a sample of the larger population. Use the named range AnnualSales. Add a rounding function to the formula in cell D5 to round the result to two decimal places. In cell B6, enter a formula to calculate the average commission. Use the named range CommissionEarned. In cell C6, enter a formula to calculate the median commission. Use the named range CommissionEarned. In cell D6, enter a formula to calculate the standard deviation for commissions. This dataset is a sample of the larger population. Use the named range CommissionEarned. Add a rounding function to the formula in cell D6 to round

the result to two decimal places. If necessary, format cells B5:D6 with the default Accounting Number Format.