The default field setting in the ____ area is to calculate a sum of the items in this drop area by the categories in the Row Labels area or Column Labels area.
A) TABLE
B) CELLS
C) CHART
D) VALUES

Question

Quizplus · Accepted Answer

The default field setting for calculating a sum of items by categories is in the Values area of a pivot table. The other options listed (Table, Cells, Chart) do not have a default field setting for summing items by categories.

The Default Field Setting in the ____ Area Is to Calculate