What is the main function of a pivot table in data analysis?

• A. To calculate, summarize, and analyze data for comparisons, patterns, and trends
• B. To store data for long-term use
• C. To format cells automatically
• D. To import data from external sources

Answer: (C)

Pivot tables are all about turning messy data into a concise, actionable summary by calculating totals, averages, counts, and other measures across different categories. They let you reorganize data by dragging fields into rows, columns, values, and filters so you can compare patterns and trends across dimensions like region, product, or time. For example, you could quickly see total sales by region and month or average order value by product category, and you can drill down or slice the data to explore specific slices. This dynamic summarization is what makes pivot tables powerful. They aren’t primarily used for storing data, formatting cells, or importing data from external sources.