How can you filter for values less than a specific number?

• A. Use a random sort and then inspect
• B. Click the filter icon in the column header, choose "Filter by condition," select "Less than," enter the value, and click "OK"
• C. Filter by color only
• D. Use 'Greater than' instead

Answer: (B)

The key idea is applying a numeric condition to filter the data. To show only values below a specific number, open the column's filter, pick Filter by condition, choose Less than, enter the threshold, and confirm. This displays only the rows whose values are under that number, making analysis focused on the smaller values. Other methods don’t accomplish that: a random sort changes order but doesn't limit results; filtering by color ignores numeric values; using Greater than selects values above the threshold rather than below.