What Dictates the Order of Hierarchy of Fields in the Rows

question 17

Multiple Choice

What dictates the order of hierarchy of fields in the rows of a PivotTable?

• A)alphabetical order
• B)the order of the fields in the ROWS area.
• C)the order of the fields in the COLUMNS area
• D)the rank in the sort order dialog box.

---

Definitions:

At the Margin

Decision making based on the additional benefit or cost of one more unit of change, often used in economic analysis.

Opportunity Cost

The burden of passing over the next top choice in the hierarchy of options when deciding.

Average Cost

Calculated by dividing the total cost of production by the number of goods produced, representing the cost per unit.

Minimum Price

The lowest legally allowed price at which a good or service can be sold, often set to protect producers or promote fair trade.