1. In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26.
   1. In cell B5, enter a formula to calculate the average annual sales for all sales associates. Use the named range AnnualSales.
   2. In cell C5, enter a formula to calculate the median annual sales for all sales associates. Use the named range AnnualSales.
   3. 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.
   4. Add a rounding function to the formula in cell D5 to round the result to two decimal places.
   5. In cell B6, enter a formula to calculate the average commission. Use the named range CommissionEarned.
   6. In cell C6, enter a formula to calculate the median commission. Use the named range CommissionEarned.
   7. 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.
   8. Add a rounding function to the formula in cell D6 to round the result to two decimal places.
   9. If necessary, format cells B5:D6 with the default Accounting Number Format.