[Solved] how do you update pivot table report data after changes are made to the source data?

McqMate

Q.	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» C. Click the report, and on the pivot table toolbar, click the refresh data button

686

0

Do you find this helpful?

9

View all MCQs in

Microsoft Access (MS Access)

Discussion

No comments yet

Related MCQs

How can you display Pivot Table report summary data in a currency format?
How can you display pivot table report summary data in a currency format?
How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
In the second subform wizard dialog box you specify the table to use as the data source and the
While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
What is the type of query that extracts data from a table and puts them into separate table?