Multiple Choice
Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?
A) Select the appropriate cell in the PivotTable and type =AVERAGE(Price) .
B) Click the AVERAGE button on the Analyze tab.
C) Right click the appropriate cell and select AVERAGE from the mini-tool bar.
D) Click the field's arrow in the VALUES area and select Value Field Settings.
Correct Answer:

Verified
Correct Answer:
Verified
Q24: A PivotChart _.<br>A)is not altered by filters
Q25: Auto Outline creates an outline based on
Q26: Which of the following is true about
Q27: _ is the process of analyzing large
Q28: Match each of the following terms to
Q30: Which option would clear a PivotTable filter
Q31: You would like to see both average
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