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.
Answer: D
You might also like to view...
Which Constitutional amendment directly addresses a citizen’s right to privacy?
a. The First Amendment b. The Fourth Amendment c. The Fifth Amendment d. Searches were not specifically defined in the Constitution.
To link a chart, you select the ________ option in the Paste Special dialog box
A) Paste link B) Paste C) Paste chart D) Paste object
The maximum number of characters for a password is 255
Indicate whether the statement is true or false
Which of the following is the goal of establishing a loop-free environment?
A) This allows a switch to learn MAC addresses. B) This allows a switch to forward only one copy of the message to the destination. C) This allows the switch to examine the source MAC address of each frame. D) This allows the switch to decide whether or not to forward a frame.