A(n) _____ summarizes large amounts of worksheet data in a compact table format.
A) Area chart
B) PivotTable
C) Slicer
D) Filter

Question

Quizplus · Accepted Answer

A PivotTable summarizes large amounts of worksheet data in a compact table format. An area chart is a type of chart used to represent data over time. A Slicer is a visual representation of a filter that allows users to filter data in a PivotTable or PivotChart. A Filter allows users to selectively display data based on certain criteria. None of these options match the description of summarizing large amounts of data in a compact table format.

A(n) _____ Summarizes Large Amounts of Worksheet Data in a Compact