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:

Pacific Northwest

A geographic region in the northwestern United States and western Canada, known for its diverse landscapes, including forests, mountains, and coastlines.

Tar Sands

Naturally occurring mixtures of sand or clay, water, and an extremely dense and viscous form of petroleum technically referred to as bitumen.

Oil Seep

The seepage of liquid petroleum at the surface.

Tar Pits

Natural deposits where a form of petroleum called bitumen seeps to the surface, creating pools of tar known for preserving ancient biological specimens.