Which statement is true about the relationship between sorting and filtering?

• A. Sorting changes the order of rows; filtering hides non-matching rows.
• B. Filtering changes the order of rows.
• C. Sorting hides non-matching rows.
• D. Filtering counts non-blank cells.

Answer: (A)

Sorting rearranges the rows based on a column’s values, changing the order but not removing any rows. Filtering, meanwhile, shows only the rows that meet specified criteria and hides the rest. So the correct relationship is that sorting changes the order of rows while filtering hides non-matching rows. These tools operate independently and can be used together—you might filter to focus on a subset and then sort that subset, or sort first and then filter. The other statements misstate what each function does: filtering doesn’t change order, sorting doesn’t hide rows, and filtering isn’t about counting non-blank cells.