If you want to view data that meets a condition without deleting, which feature would you use?

• A. Charting
• B. Filtering
• C. Sorting
• D. Conditional formatting

Answer: (B)

Viewing a subset of data that meets a condition without removing anything relies on filtering. Filtering hides rows that don’t match your rule, letting you focus on the records that do while keeping all data intact. This non-destructive approach means you can apply a condition (like sales > 1000), view only the matching rows, and then easily clear the filter to see all data again. In contrast, sorting changes the order of all rows, charts visualize data but don’t limit what you see, and conditional formatting highlights cells that meet a condition without hiding other data. So filtering is the best tool for viewing data that meets a condition without deleting.