Free CES PivotTables & Data Manipulation Questions and Answers — Questions and Answers
Question 1: What is a PivotTable used for in Excel?
- To create charts.
- To filter data only.
- To summarize and analyze large datasets (Correct answer)
- To create formulas.
Correct answer: To summarize and analyze large datasets
PivotTables are powerful Excel tools that allow users to quickly summarize, analyze, explore, and present large amounts of data. They enable dynamic rearrangement of data to view it from different perspectives, making it easier to identify patterns, trends, and insights. This capability is essential for efficient data analysis.
Question 2: How can you refresh a PivotTable after the source data is updated?
- By deleting the PivotTable and recreating it.
- By manually updating each cell.
- By clicking the 'Refresh' button (Correct answer)
- By exporting the data.
Correct answer: By clicking the 'Refresh' button
When the source data for a PivotTable is updated, the PivotTable itself does not automatically reflect these changes. To incorporate the new data and ensure the PivotTable displays the most current information, you must manually refresh it. This is done by clicking the 'Refresh' button, typically found in the Analyze tab under PivotTable Tools.
Free CES PivotTables & Data Manipulation Questions and Answers
What is a PivotTable used for in Excel?