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 ROWS area and then choose Average.
B) Add sales to the VALUES area once and select both AVERAGE and SUM functions.
C) Add sales to the COLUMNS area.
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.
D
You might also like to view...
What symbol is used to indicate a destructor function?
A. : B. :: C. ~ D. >>
Which of the following is incorrect?
a. A constructor may be static. b. A constructor may be private. c. A constructor may invoke a static method. d. A constructor may invoke an overloaded constructor. e. A constructor invokes its superclass no-arg constructor by default if a constructor does not invoke an overloaded constructor or its superclass’s constructor.
A kiosk presentation loops continually with no need for a presenter
Indicate whether the statement is true or false
What command can be used to cause a group policy refresh remotely on Windows Vista and later clients?
A. Invoke-GPUpdate B. gpupdate.exe C. Remote-GPUpdate D. gpremote.exe