Q500
how do you update pivot table report data after changes are made to the source data?
A.
Save your changes, close the workbook, and then reopen it.
B.
Select the pivot table worksheet and press f9 on the keyboard
C.
Click the report, and on the pivot table toolbar, click the refresh data button
AnswerD.
All of the above
Answer: Option C
Solution
Answer: Option C
Solution:
When changes are made to the source data of a pivot table, the pivot table itself does not automatically update.To refresh the pivot table with the updated data, you need to click on the pivot table report.
Then, on the pivot table toolbar, you can find the "Refresh Data" button which will update the report with the latest data from the source.
Therefore, the correct method is to click the refresh data button, making Option C the correct answer.