Solved

Which Is an Effective Way to Change a SUM of Price

Question 29

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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions