What is the typical effect of using a pivot table to analyze data?

• A. It allows the data to be rearranged without changing the source data
• B. It modifies the original dataset
• C. It prevents further calculations
• D. It requires advanced coding

Answer: (A)

Pivot tables let you summarize and rearrange data in a separate view without modifying the original dataset. You can drag fields into rows, columns, and values to see totals, counts, averages, and other measures by category or time period, making it easy to spot patterns. Because the output is a separate table, the source data remains intact and you can refresh the pivot table if the underlying data changes. This approach doesn’t modify the original data, doesn’t block further calculations, and doesn’t require advanced coding.