If you change the underlying data on which a PivotTable report is based,you must also ________ or update the PivotTable to reflect the new data.
A)refresh
B)list
C)save
D)reopen

Question

Quizplus · Accepted Answer

To reflect the new data in a PivotTable report, you must refresh it. Refreshing a PivotTable updates it with changes made to the underlying data without altering the PivotTable layout or format. It ensures that the report accurately reflects the current state of the data, including any new or deleted items. The other options, such as saving, reopening, or listing, do not modify the PivotTable or update it with new data.

If You Change the Underlying Data on Which a PivotTable