What is a key benefit of using a pivot table on a dataset?

• A. It duplicates the dataset into a new sheet only.
• B. It replaces the need for any data collection.
• C. It summarizes and analyzes data without altering the source data.
• D. It removes duplicates from the dataset.

Answer: (C)

Pivot tables provide fast, flexible summarization of data without changing the source data. They let you compute aggregates like sums, averages, and counts, and you can group and rearrange data by different categories to see how the results vary. This on-the-fly reorganization makes it easy to explore patterns, totals, and distributions across many records while keeping the original dataset intact. The other options miss the main idea: a pivot table isn’t just duplicating the dataset into a new sheet; it creates a concise, interactive summary. It doesn’t replace data collection, and it doesn’t remove duplicates from the source data—duplicates remain in the original dataset, while the pivot presents summarized results.