Microsoft Excel PivotTables and PivotCharts 1 — Questions and Answers
Question 1: What is a PivotTable in Microsoft Excel?
- A chart type that rotates around a central axis
- A table with locked cells that cannot be edited
- An interactive tool that summarizes large data sets into a compact, organized format (Correct answer)
- A table that automatically converts data to percentages
Correct answer: An interactive tool that summarizes large data sets into a compact, organized format
A PivotTable is an interactive data summarization tool that reorganizes and aggregates large data sets for easier analysis.
Question 2: Which tab in Excel's ribbon is used to insert a PivotTable?
- Home
- Data
- Formulas
- Insert (Correct answer)
Correct answer: Insert
PivotTables are inserted from the Insert tab by clicking the PivotTable button in the Tables group.
Question 3: Which of the following is NOT one of the four field areas in the PivotTable Fields pane?
- Rows
- Values
- Headers (Correct answer)
- Filters
Correct answer: Headers
The four PivotTable field areas are Rows, Columns, Values, and Filters — Headers is not a PivotTable field area.
Question 4: What default summary function does the Values area use for numeric fields in a PivotTable?
- COUNT
- AVERAGE
- MAX
- SUM (Correct answer)
Correct answer: SUM
Excel defaults to SUM when a numeric field is placed in the Values area of a PivotTable.
Question 5: What does refreshing a PivotTable do?
- Deletes all filters applied to the PivotTable
- Converts the PivotTable to a regular table
- Updates the PivotTable to reflect changes in the source data (Correct answer)
- Resets the PivotTable layout to the default
Correct answer: Updates the PivotTable to reflect changes in the source data
Refreshing updates the PivotTable to incorporate any additions, deletions, or changes made to the source data.
Question 6: What is a Slicer in Microsoft Excel?
- A keyboard shortcut for filtering data
- A function that splits text into separate cells
- A tool that removes duplicate rows from a PivotTable
- A visual filter control that provides clickable buttons for filtering PivotTable data (Correct answer)
Correct answer: A visual filter control that provides clickable buttons for filtering PivotTable data
A Slicer is a visual filter control with clickable buttons that allows users to quickly filter PivotTable or Table data interactively.
Question 7: What happens when you double-click a value cell in a PivotTable?
- The value is highlighted for editing
- A dialog box opens to change the value
- Excel drills down and creates a new sheet showing the underlying detail records (Correct answer)
- The cell is merged with adjacent cells
Correct answer: Excel drills down and creates a new sheet showing the underlying detail records
Double-clicking a value cell drills down to show the source records that make up that aggregated value on a new worksheet.
Microsoft Excel PivotTables and PivotCharts 1
What is a PivotTable in Microsoft Excel?