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

question 354

Multiple Choice

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

---

Definitions:

Parents Divorce

The legal termination of a marital relationship involving parents, which can have various emotional and psychological impacts on their children.

Psychosocial Development

(1) Pattern of change in emotions, personality, and social relationships. (2) In Erikson’s eight-stage theory, the socially and culturally influenced process of development of the ego, or self.

Industry

Refers to the economic sector concerned with the production, processing, and distribution of goods and services.

Erik Erikson

A psychologist known for his theory on psychosocial development across the lifespan, identifying stages of growth from infancy to late adulthood.