Question

You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data. a. change b. renew c. reset d. refresh

Answer 1

D. Refresh.

Step-by-step explanation:

Microsoft Excel is a spreadsheet application used to analyze data. It has rows and columns which are also known as records and field, use to locate cells in the worksheet.

The pivot table is a tool in excel created from a table. It has special analytic features normal excel table don't have. A data cell in the pivot table can not be edited direct on the pivot, but through the original table. The cell in the original table is edited and refreshed to update the pivot table to it's current state.

Answer 2

d. refresh

Step-by-step explanation:

The Excel software does not allow a user to change values/data directly in the Pivottable. You will get an error message like "Cannot change this part of a PivotTable report" when you try to type data directly. You will have to edit the Excel Table and then refresh to reflect the updated data.