How Can You Drill Down a PivotTable to Display Detailed

question 243

Multiple Choice

How can you drill down a PivotTable to display detailed data?

• A) Double-click a cell in the PivotTable.
• B) Right-click a cell in the PivotTable, and then click Details.
• C) Add a field to the Drill area of the PivotTable.
• D) Click the minus button next to a field in the PivotTable.

---

Definitions:

P Chart

A statistical chart, known as a control chart, used for monitoring the proportion of defectives in a process over time.

Expected Monetary Value

The predicted average outcome of a decision if it can be repeated many times.

Incentive Programs

Schemes designed to motivate and reward desired behaviors or performance from individuals or groups.

State of Nature

A term used in decision theory referring to the actual but possibly unknown status of the world, which affects the outcomes of decisions.