What do custom filters provide that AutoFilters don’t? 1 point: – Set multiple filters at the same time – Associate a formula with the filter – Control filter a column to see only above or below a certain value – Display more data
The correct answer and explanation is:
Correct Answer: ✅ Control filter a column to see only above or below a certain value
Explanation (300 words):
In spreadsheet applications like Microsoft Excel and Google Sheets, both AutoFilters and Custom Filters are tools used to narrow down data to focus on specific information. However, they differ in terms of flexibility and complexity.
AutoFilters are the basic filtering option that allows users to quickly sort and filter data using predefined options such as:
- Selecting specific items from a dropdown list.
- Filtering by text (e.g., “Begins with”, “Ends with”).
- Filtering by number or date using equal to, less than, etc.
However, AutoFilters are somewhat limited in advanced scenarios. This is where Custom Filters come in.
Custom Filters allow more advanced and conditional filtering, such as:
- Filtering values that are greater than, less than, equal to, or between two numbers or dates.
- Combining multiple conditions with AND or OR logic.
- Filtering based on custom text criteria (e.g., “does not contain” or “contains specific characters”).
The key advantage—and the correct answer to this question—is that Custom Filters allow you to filter a column to see only values above or below a certain threshold, which AutoFilters can’t do as precisely.
For example, if you want to display only rows where the sales are greater than \$500, a Custom Filter allows that. An AutoFilter might require you to manually scroll and check boxes, which is inefficient for large datasets.
Custom Filters do not:
- Associate a formula with the filter.
- Display more data (they restrict data).
- Set filters on multiple columns at once any more than AutoFilters already do.
Thus, the main added benefit of Custom Filters is greater control, especially for numeric and date-based conditions.