Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?
a.
Right click the appropriate cell and select AVERAGE from the mini-tool bar
b.
Select the appropriate cell in the PivotTable and type =AVERAGE(Price)
c.
Click the field's arrow in the VALUES area and select Value Field Settings
d.
Click the AVERAGE button on the Analyze tab
Answer: c.
Click the field's arrow in the VALUES area and select Value Field Settings
If the answers is incorrect or not given, you can answer the above question in the comment box. If the answers is incorrect or not given, you can answer the above question in the comment box.