What is the main purpose of a **Pivot Table** in Excel?
B
To sort data alphabetically
C
To summarize and analyze large datasets
Analysis & Theory
A Pivot Table helps to **summarize, analyze, explore, and present** large amounts of data.
Where can you create a Pivot Table in Excel?
B
Insert tab > PivotTable
D
Review tab > New Comment
Analysis & Theory
Go to the **Insert tab** and click **PivotTable** to create one.
What is required to create a Pivot Table?
Analysis & Theory
Pivot Tables require a **structured dataset with headers** for each column.
Which of the following is NOT a common area in a Pivot Table field list?
Analysis & Theory
The four main Pivot Table areas are **Rows**, **Columns**, **Values**, and **Filters** — not Themes.
What does the **Values** area of a Pivot Table typically contain?
B
Data to be counted or summarized
Analysis & Theory
**Values** area holds the data that gets **summed, counted, or averaged** in the Pivot Table.
Can you filter data in a Pivot Table?
A
No, filters only apply to worksheets
B
Yes, using the Filter area or filter dropdowns
Analysis & Theory
Pivot Tables can be filtered using the **Filters pane** or by clicking dropdowns in Rows or Columns.
What is the advantage of using a Pivot Table over regular formulas?
B
Dynamic and faster data analysis
C
Better formatting options
D
Converts text to numbers
Analysis & Theory
Pivot Tables make data **analysis faster and dynamic** compared to manual formulas.
Can Pivot Tables summarize data using functions like **Sum, Count, and Average**?
A
No, only Sum is allowed
B
Yes, you can choose different summary functions
Analysis & Theory
Pivot Tables support many summary functions like **Sum, Count, Max, Min, Average**, etc.
How can you update a Pivot Table when the source data changes?
A
Click Refresh under PivotTable Tools
B
It updates automatically
D
Reinsert the Pivot Table
Analysis & Theory
Click **Refresh** under the PivotTable Analyze tab to update it with new data.
Can you create charts from Pivot Tables?
A
No, charts only work with raw data
Analysis & Theory
**PivotCharts** are charts that are directly based on Pivot Table data.