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
D. All of the above
Answer: Option C
Solution (By Examveda Team)
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.
This Question Belongs to Computer Fundamentals >> MS Access
Join The Discussion
Comments (1)
Related Questions on MS Access
Press the following keys in Access to Save a database object
A. CTRL+P
B. P or CTRL+P
C. CTRL+S or SHIFT+F12
D. F12
A. Move up one line
B. Move up one page
C. Exit the combo box or list box
D. None of these
Answer should be all the above..