What is the primary purpose of a pivot table?

• A. To summarize and analyze data by category and metric
• B. To store raw data without any calculation
• C. To replace all charts
• D. To delete duplicate records

Answer: (A)

Pivot tables summarize and analyze data by category and metric. They take a large dataset and reorganize it so you can see patterns at a glance—grouping data by things like region, product, or date and calculating numbers such as total sales, average order value, or counts. By dragging category fields into rows or columns and placing numeric fields into values, you get a cross-tabulated view that reveals how different groups compare.

This dynamic view updates as the underlying data changes, making it easy to explore different angles—like identifying which region or product drives most revenue, or how performance varies over time. It’s not a place to store raw data, and it doesn’t replace charts. Charts visualize the summaries, while a pivot table provides the underlying summarized insight. It also doesn’t delete duplicates; duplicates remain in the source data.