You Created a PivotTable and Later Made Changes to Values

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.