What are filters in UI design?
Filters provide a set of controls to reduce items in a collection based on attributes the user is interested in (e.g., filtering items by creation date). Filters can provide the following functionality: A list of interesting attributes common to items in a collection, and possible values to filter by.
What is the purpose of advanced filtering in a data sheet?
Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook. Advanced Filter has several useful features. It allows you to apply several filter criteria simultaneously to the entire data file, which AutoFilter does not.