How can you filter data in a column?

• A. By deleting all non-matching data
• B. By exporting the column to CSV
• C. By specifying a condition that data must meet, which hides all non-matching data in that column
• D. By sorting in ascending order only

Answer: (C)

Filtering data in a column means applying a condition so that only the rows meeting that condition are shown, while all non-matching rows are hidden from view. This lets you focus on the subset you care about without altering or deleting the underlying data. It’s a reversible operation: you can change or remove the filter to see all rows again. Deleting non-matching data would remove those rows permanently, exporting to CSV copies the data as it is with no filtering, and sorting only rearranges the order without hiding any rows.