1.

describe the difference between the AutoFilter and the Advanced Filter features. Provide an example of a situation when it would be beneficial to use one feature over the other.

Answer»

ong>ANSWER:

Complex Filters

For example, with an AutoFilter, you can SELECT two specific customers, and two products for those selected customers. With an Advanced Filter, you can create OR CONDITIONS between columns, such as Customer A OR Product B -- you can't do that in an AutoFilter!



Discussion

No Comment Found

Related InterviewSolutions