Multiple Choice
Moving one of two fields from the ROWS area to the COLUMNS area of a PivotTable would ________.
A) divide the values by the number of columns
B) consolidate data and remove redundant labels
C) have no impact on the outcome
D) make the table twice as long
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q15: How would you add a date filter
Q16: Build a PivotChart in the PivotChart wizard
Q17: What dictates the order of hierarchy of
Q18: The four areas for organizing fields in
Q19: Creating a data model in Excel is
Q21: Given a list of candy bars in
Q22: The _ area is replaced with the
Q23: What field is in the ROWS area
Q24: A PivotChart _.<br>A)is not altered by filters
Q25: Auto Outline creates an outline based on