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.

Question

Quizplus · Accepted Answer

Clicking on the field's arrow in the VALUES area and selecting Value Field Settings opens up the dialog box where we can change the function from SUM to AVERAGE.

Which Is an Effective Way to Change a SUM of Price