Question

Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data?

a) Pivot table
b) Pivot chart
c) Data table
d) Group table

Answer 1

A pivot table is an interactive view of worksheet data that allows users to summarize the data by selecting categories to group the data.

Step-by-step explanation:

The interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data is called a Pivot table. Pivot tables are a powerful tool in spreadsheet programs like Microsoft Excel. They allow you to rearrange and summarize large amounts of data in a convenient way.