You would like to see both average sales and total sales for a category in a pivot table. Which of these would best accomplish both a Total and an Average column on the field Sales?
A. Add sales to the VALUES area once and select both AVERAGE and SUM functions.
B. Add sales to the COLUMNS area.
C. Add sales to the ROWS area and then choose Average.
D. Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat, allowing it to default to SUM.
Answer: D
You might also like to view...
The signal system call is used to
A. specify a response to a particular signal B. kill a process
Information functions provide information about a cell's contents
Indicate whether the statement is true or false.
Just knowing that a corporation has invested in a dedicated facility for performing forensic investigations has an impact on the corporate culture
a. True b. False
A system administrator is selecting an operating system for use by the company’s research and development team. The team requires an OS that can be easily modified and changed to meet its particular requirements. Which of the following operating systems will be the best choice for the users?
A. Windows 10 Enterprise B. Mac OS X C. Linux D. Windows 7 Professional