All of the Following Statements Are TRUE Regarding PivotTable and PivotChart

question 3

Multiple Choice

All of the following statements are TRUE regarding PivotTable and PivotChart best practices EXCEPT:

• A)Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate.
• B)Once you have selected your data, ensure the source data are arranged in an area with column headings representing each field and the rows representing each record.
• C)Distinguish fields as either grouping variables or slicer variables.
• D)Know who your audience is prior to developing your PivotTable or PivotChart. It could make a difference in how much detail you display.

---

Definitions:

Marginal Utility

The incremental utility or happiness a consumer derives from acquiring and using an additional unit of a good or service.

Utility Per Dollar

A measure of the satisfaction or usefulness obtained from purchasing goods or services relative to the amount of money spent.

Diminishing Marginal Utility

The principle stating that as more of a good or service is consumed, the marginal benefit of additional units will decline.

Utility Maximization

The process by which consumers adjust their consumption to achieve the highest level of satisfaction from their available resources.