You Created a PivotTable and Later Made Changes to Values

question 54

Multiple Choice

You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?

• A)The PivotTable updates automatically when you make changes to the dataset.
• B)Excel gives an error message that data has changed and the PivotTable may no longer be accurate.
• C)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
• D)Excel deletes the PivotTable automatically so you can recreate it.

---

Definitions:

Data Types

Defined categories for data within programming and database environments that determine the kind of data values that can be stored and manipulated within a column or variable.

Target Table

In database operations, especially in insertion or update actions, the table in which data is to be added or modified.

Join Line

A graphical representation in database software that illustrates the relationship or linkage between two database tables based on common fields.

Connection Line

In diagrams or graphical user interfaces, a line that visually links different components to show relationships or data flow.