What Can You Do When You Have Two Levels of Data

question 329

Multiple Choice

What can you do when you have two levels of data in PivotTable rows?

• A) Add a calculated row to the PivotTable.
• B) Use the Collapse and Expand buttons to drill down and up in the data.
• C) Filter the PivotTable on two columns.
• D) Create a 3-D PivotChart.

---

Definitions:

Confirmatory Value

The aspect of relevant financial information that helps users of financial statements confirm or correct prior expectations.

Mispriced Security

A financial security (such as a stock or bond) that is selling for a price significantly different from its intrinsic value.

Faithful Representation

An accounting principle that financial data must be complete, neutral, and free from error, accurately representing the financial reality.

Comparability

An accounting principle that ensures financial statements can be easily compared across different periods or companies, enhancing transparency.