Question

Advanced filter enable you filter criteria​

Answer 1

Answer:

In the creteria range for an excel advanced filter, you can set the results for the data that should remain visible after the filter is applied. You can use one criterion, or several. WARNING: When you use text creteria, Excel Interprets it as "begins with". If you need an exact match, see the exact match example below.

Explanation:

PLEASE FOLLOW ME AND MARK ME AS A BRAINLIST AND ALSO THANK ME IF MY ANSWER IS CORRECT.