What is the purpose of a pivot table in spreadsheets?

• A. A pivot table categorizes data to identify insights or trends without changing the original data.
• B. It automatically creates charts from the data.
• C. It changes the original data to reflect new calculations.
• D. It filters data randomly.

Answer: (A)

Pivot tables summarize and reorganize data to reveal patterns and totals without changing the underlying dataset. By dragging fields into rows, columns, and values, you group data by categories and apply aggregates like sum, average, and count, making it easy to spot trends such as which region or product drives the most sales. This dynamic view lets you explore different perspectives without altering the original data, so you can slice data to uncover insights while keeping the source intact. Charts can be built from pivot table results, but creating charts is a separate step—the pivot table itself is about summarization, not automatic chart creation. It also avoids random filtering; any filtering is intentional and deterministic, with the original values remaining unchanged.