Multiple Choice
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
Correct Answer:
Verified
Q1: A(n)_ of original data should be made
Q2: When using the _ Filter feature,filtering criteria
Q3: All of the following statements are TRUE
Q4: Users can change the look of an
Q5: To _ data means to consolidate or
Q7: Which of the following statements about filtering
Q8: A PivotTable can be created on a
Q9: The _ function will run calculations on
Q10: By default,PivotTables show a _ for both
Q11: If the criteria range for the Advanced