If You Create a Recommended PivotTable on a Group of Data

question 64

Multiple Choice

If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e.Business) , Area (i.e.Finance and Marketing) , Units Sold, Wholesale Price, what column might Excel use as values?

• A)Discipline
• B)Area
• C)Units Sold
• D)Both Discipline and Area

---

Definitions:

Inventory Costing

The method used to value inventory, including approaches like Last In, First Out (LIFO), First In, First Out (FIFO), and Weighted Average Cost.

Accounting Principles

The rules and guidelines that companies must follow when reporting financial data.

Consequences

Refers to the outcomes, effects, or results that follow from specific actions, decisions, or conditions.

Dollar-Value LIFO

An inflation-adjusted LIFO method that groups inventory into pools based on dollar value rather than physical units, protecting against inflationary effects.