dataset and would like to make sure our previously created PivotTables and PivotCharts are updated to reflect the newly added data. You can also assume that the cell
Ma3.
Assume we have added new data to a dataset and would like to make sure our previously created PivotTables and PivotCharts are updated to reflect the newly added data. You can also assume that the cell range used within the PivotTable and PivotCha would capture this newly added data. Which of the following statements is TRUE?
A. To update the analysis after new data is added, the Format button in the Home tab must be clicked.
B. To update the analysis after new data is added, the Refresh All button in the Data tab must be clicked.
C. To update the analysis after new data is added, the Data Analysis button in the Data tab must be clicked.
D.The newly added data will automatically be updated within the previously created PivotTables and PivotCharts.
Step by step
Solved in 2 steps
