Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?
A) Click the field's arrow in the VALUES area and select Value Field Settings.
B) Select the appropriate cell in the PivotTable and type =AVERAGE(Price).
C) Click the AVERAGE button on the Analyze tab.
D) Right click the appropriate cell and select AVERAGE from the mini-tool bar.
A
Computer Science & Information Technology
You might also like to view...
A ________ is a short post from a member of a social networking site, conveying the user's current thoughts, actions, and so forth
A) pin B) profile C) status update D) plot
Computer Science & Information Technology
What can be used in conjunction with manual audits to provide a faster means to evaluate programs?
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology