Question

Which among the following features is used to filter data multiply field using a specified criteria

Answer 1

Answer:

To create an AND criteria, put your criteria on the same row, for example, Product = AAA-1 AND Order < 50.

...

Filter data by multiple criteria with Advanced Filter

Product = AAA-1 and Order < 50,Product = CCC-3 and Name = Helen,Product = EEE-5 and Total price > 5000.

Explanation:

Hope it helped you...