You Cannot Change Data Directly in the PivotTable

question 5

Multiple Choice

You cannot change data directly in the PivotTable.Instead,you must edit the Excel table,and then ____,or update,the PivotTable to reflect the updated data.

• A)reset
• B)refresh
• C)renew
• D)change

---

Definitions:

Standard Deviations

A gauge for evaluating how much the data values vary or diverge from each other in a dataset.

Data Values

The individual pieces of information or numerical figures that are collected and analyzed in a study.

Interactive Data Dashboards

Visual displays of data that allow users to filter, analyze, and interact with complex datasets in real-time.

Drilling Down

A method in data analysis where you move from summary information to more detailed data.