You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.
A) switch
B) relate
C) refresh
D) group

Question

Quizplus · Accepted Answer

Grouping allows you to analyze specific values in a field, such as revenue data for two quarters, by combining and summarizing multiple rows or columns of data. Switching, relating, and refreshing do not allow for this specific type of analysis.

You Can _____ PivotTable Data to Analyze Specific Values in a Field