A(n) _____ groups and summarizes data in a concise format of rows and columns.
A) Area chart
B) PivotTable
C) Slicer
D) Filter

Question

Quizplus · Accepted Answer

A PivotTable is a tool in Excel that allows users to group and summarize data in a concise format of rows and columns. PivotTables provide a quick way to analyze large amounts of data and view it from different perspectives. The other options (Area chart, Slicer, and Filter) do not necessarily group and summarize data in the same way as a PivotTable.

A(n) _____ Groups and Summarizes Data in a Concise Format