How can subtotals be used in a worksheet?

• A. To eliminate duplicate records
• B. To summarize data for a group of records while displaying detailed records
• C. To filter out unnecessary information
• D. To sort records based on specific criteria

Answer: (B)

Subtotals in a worksheet are used to summarize data for a group of records while still displaying the detailed records. This functionality is particularly powerful when working with large datasets where it is important to understand the total of specific categories without losing sight of the individual items that contribute to those totals. By applying subtotals, users can organize their data into groups, calculate aggregate values such as sums or averages for each group, and retain visibility of the underlying detail that informs those aggregates.

When subtotals are added, they can create a clearer and more structured view of the data, allowing for easier analysis and reporting. This capability is essential in various scenarios, such as financial reporting or project management, where both summary and detailed views are needed for effective decision-making.