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 program that runs in the browser to add interactive content to the Web page is called a(n):

A) thread B) post C) script D) pop-up

Computer Science & Information Technology

JavaScript has no separate declaration for constants, so constants are declared as variables.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Forensic laboratories should be equipped with ________ so that criminal contraband can be permanently removed from suspect machines

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

There are two primary types of user interfaces: the graphical user interface and the command line interface.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology