In a PivotTable, when a field is dragged to the Values section below the PivotTable Field List, the default value setting is ____.
A) Average
B) Count
C) Max
D) Sum

Question

Quizplus · Accepted Answer

The default value setting when dragging a field to the Values section in a PivotTable is Sum. This is because the Values section is used to display the numeric values of the data, and Sum is often the most appropriate calculation to use for numeric data.

In a PivotTable, When a Field Is Dragged to the Values