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:

Cultural Diffusion

The spread of cultural elements such as beliefs, practices, and technologies from one society or cultural group to another.

Cultural Group

A collection of people who share common cultural characteristics, such as language, values, customs, and traditions.

Graying of America

A term used to describe the demographic trend in the United States towards a larger proportion of the population being elderly, as a result of aging baby boomers and increased life expectancy.

Population Bomb

A term popularized in the late 20th century referring to the potential negative consequences of rapid population growth, including environmental degradation, resource depletion, and social unrest.