When editing a PivotTable where are values field settings edited?
A)PivotTable Design tab
B)Data tab
C)PivotTable Fields task pane
D)Formulas tab

Question

Quizplus · Accepted Answer

Values field settings are edited in the PivotTable Fields task pane. This allows you to change the calculation type, number format, and other settings for the values in your PivotTable. The PivotTable Design and Data tabs are used for formatting and manipulating the data source, while the Formulas tab is used for creating or editing formulas related to the PivotTable data.

When Editing a PivotTable Where Are Values Field Settings Edited