Asked by zachary kastner on Jun 09, 2024
Verified
How can you change the data displayed in the PivotTable?
A) Edit the PivotTable directly.
B) Edit the data source and then refresh the PivotTable.
C) Use the Edit in Place feature.
D) Edit the data source and then save the workbook.
Edit Data Source
An option in software applications that allows users to modify the origin of the data being used, such as changing the database or spreadsheet being accessed.
Refresh PivotTable
An action in spreadsheet software that updates the pivot table's data and calculations to reflect changes in the source data.
Edit in Place
A feature that allows users to directly edit the content of a web page or document within its display or context, without needing to navigate to a separate editing interface.
- Become adept at altering PivotTable and PivotChart elements to enhance data visualization.
- Renew and enhance PivotCharts and PivotTables to display updates in the primary data source.
Verified Answer
CL
Cameron LewallenJun 12, 2024
Final Answer :
B
Explanation :
To change the data displayed in a PivotTable, you need to edit the underlying data source and then refresh the PivotTable. This will ensure that any changes made in the data source are reflected in the PivotTable. Editing the PivotTable directly or using the Edit in Place feature is not a recommended method as it may not update the data in the data source. Saving the workbook after editing the data source is also not necessary to update the PivotTable, refreshing it is sufficient.
Learning Objectives
- Become adept at altering PivotTable and PivotChart elements to enhance data visualization.
- Renew and enhance PivotCharts and PivotTables to display updates in the primary data source.