Multiple Choice
You would like to see both average sales and total sales for a category in a pivot table.Which of these would best accomplish both a Total and an Average column on the field Sales?
A) Add sales to the VALUES area once and select both AVERAGE and SUM functions.
B) Add sales to the COLUMNS area.
C) Add sales to the ROWS area and then choose Average.
D) 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.
Correct Answer:

Verified
Correct Answer:
Verified
Q26: Which of the following is true about
Q27: _ is the process of analyzing large
Q28: Match each of the following terms to
Q29: Which is an effective way to change
Q30: Which option would clear a PivotTable filter
Q32: A(n)_ associates matching fields between 2 tables.
Q33: A calculated field must be built in
Q34: What does applying a banded row format
Q35: A primary benefit of creating a PivotTable
Q36: Which is not true about Slicers?<br>A)Aggregate values