What best describes the roles of sorting and filtering in spreadsheets?

• A. Sorting reorders data in a specific order.
• B. Filtering displays all data regardless of criteria.
• C. Sorting reorganizes data in a specific order; Filtering displays only data that meets criteria.
• D. Filtering merges data from multiple sources.

Answer: (C)

Sorting and filtering are two essential ways to work with data in a spreadsheet. Sorting reorganizes rows based on the values in a chosen column, in ascending or descending order, so you can see the data in a meaningful sequence. Filtering, by contrast, hides rows that don’t meet your specified criteria and shows only those that do, making it easier to focus on a relevant subset. Together, they describe how you view data: sorting changes the order, while filtering changes which rows are visible. The option that states both parts—sorting reorganizes data in a specific order and filtering displays only data that meets criteria—best captures how these tools operate.