Roberta added a calculated field to the Values area of a PivotTable, where it appears as "Sum of ORDERS." Where can she change the text displayed for this field?
A) Number Format dialog box
B) Calculated Field Format dialog box
C) Value Field Settings dialog box
D) PivotTable Options dialog box

Question

Quizplus · Accepted Answer

In the Value Field Settings dialog box, Roberta can change the name displayed for the calculated field. This can be accessed by right-clicking on the field in the Values area and selecting "Value Field Settings."

Roberta Added a Calculated Field to the Values Area of a PivotTable