QUESTION 11 1. In calculating both average sales and total sales in a pivot table. What steps will you take to get the calculations? A. Add sales to the COLUMNS area. B. Add sales to the ROWS area and then choose Average. c. Add sales to the VALUES area once and select both AVERAGE and SUM functions. Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat, allowing it to default to SUM. D