Multiple Choice
Which of the following statements regarding PivotTables is NOT TRUE?
A) When there are a lot of groups within a field, it is better to put those fields along the row side of the PivotTable.
B) There are three context-sensitive tabs associated with PivotTables.
C) Typically the contents of a PivotTable should go down more than across.
D) Fields for PivotTable grouping could be all in the Rows area, all in the Columns area, or a mixture.
Correct Answer:
Verified
Correct Answer:
Verified
Q43: To open the Create PivotTable dialog box,click
Q44: Because of the way that Excel is
Q45: _ is the name used for a
Q46: _ allows a user to import up
Q47: When creating a PivotTable,any existing automatic subtotals
Q49: _ variables are data that can be
Q50: To change a table back to a
Q51: Format the PivotTable or PivotChart so it
Q52: PivotTable data formatted through the _ dialog
Q53: All of the following statements are TRUE