6. Excel

Calculate the total and average sales by region.

In cell B10, use a SUMIF formula to calculate the sum of AnnualSales where the value in the Regions named range is equal to the region listed in cell B9.

Copy the formula to cells C10:I10.

In cell B11, use an AVERAGEIF formula to calculate the average of AnnualSales where the value in the Regions named range is equal to the region listed in cell B9.

Add a rounding function to the formula in cell B11 to round the result to two decimal places.

Copy the formula to cells C11:I11.

If necessary, format cells B10:I11 with the default Accounting Number FORMAT