Which term is used to describe the feature that groups and summarizes data by collapsing and expanding sections in a worksheet?

• A. Outline
• B. Subtotal
• C. Filter
• D. Pivot

Answer: (A)

Grouping and summarizing data by collapsing and expanding sections in a worksheet is done with an outline. Outlining creates levels of detail by grouping adjacent rows or columns, and it adds collapse/expand controls (like plus and minus signs) so you can hide or reveal lower-level data while keeping the higher-level totals visible. This makes it easy to compare summaries across groups without scrolling through every detail.

While filters hide rows based on criteria and subtotals perform calculations within a grouped area, the feature described by collapsing and expanding sections is the outline. Pivot tables are another powerful way to summarize data, but they are a separate tool with their own interface and purpose.