Solved

You Created a PivotTable and Later Made Changes to Values

Question 7

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.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents