All of the following statements are TRUE regarding grouping in PivotTables EXCEPT:
A) Grouping variables are placed along the top or the left side of the PivotTable.
B) The summary variables are positioned in the VALUES area below the PivotTable Fields list.
C) The grouping variables are positioned in the COLUMNS or ROWS areas at the top of the PivotTable Fields pane.
D) Dates are great for grouping into months, quarters, and years to explore trends over time.
Correct Answer:
Verified
Q32: Gender and dates are two examples of
Q33: The PivotTable _ tab focuses on formatting
Q34: PivotTable data formatted through the _ dialog
Q35: All of the following statements are TRUE
Q36: _ allows a user to import up
Q38: It is NOT recommended to use the
Q39: The context-sensitive tabs available to aid in
Q40: Use the _ button on the Options
Q41: Using Excel's Hide Rows feature is a
Q42: If the criteria range for the Advanced
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents