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

Question

Quizplus · Accepted Answer

Moving a field from the ROWS area to the COLUMNS area of a PivotTable would change the layout of the table, consolidate data, and remove redundant labels. This might make it easier to read and analyze the data, depending on the specific situation. The other options listed are not accurate.

Moving One of Two Fields from the ROWS Area to the COLUMNS