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:

Commensalism

A relationship between two organisms where one benefits and the other is neither harmed nor benefited.

Predation

The interaction between two species where one organism, the predator, feeds on another organism, the prey, as a source of energy and nutrients.

Finch Species

A group within the bird family, known for their diversity in beak shapes and sizes, which has been extensively studied in evolutionary biology.