A Field Named Difference Appears in the PivotTable Fields Pane

question 255

Multiple Choice

A field named Difference appears in the PivotTable Fields pane and in the PivotTable, where it displays the difference between the Year 1 and Year 2 fields.What type of field is Difference?

• A) Data field
• B) Calculated field
• C) Expanded field
• D) Formula field

---

Definitions:

Stockholders

Individuals or entities that own shares in a corporation, giving them proportionate ownership depending on the amount of stock held.

Utility Function

A mathematical representation that ranks consumer preferences or satisfaction levels from consuming various goods or services.

Wealth

The total value of all financial and non-financial assets owned by an individual or entity, minus any debts owed.

Diminishing Marginal Utility

A principle stating that as a person increases consumption of a product, there is a decline in the added satisfaction that comes from consuming one additional unit.