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:

Human Capital

Represents the economic value of a worker's experience and skills, including education, training, intelligence, skills, health, and other things employers value such as loyalty and punctuality.

Differences in Talent

Variations in the natural abilities, skills, or competencies among individuals that can impact productivity and earnings.

Doctoral Degrees

Advanced academic degrees awarded by universities, recognizing the highest level of expertise in a specific field of study.

Wage Differentials

The variation in wages among individuals for the same job or different jobs based on factors such as experience, education, and skill level.