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:
Verified
Q2: Given a list of candy bars in
Q3: The _ function is the default summary
Q4: If you would like to show a
Q5: What would you do to format all
Q6: A worksheet of faculty members at your
Q8: You would like to see both average
Q9: Moving one of two fields from the
Q10: Which of the following is true about
Q11: What does a + button indicate to
Q12: You have a PivotTable with 2 fields
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents