Question

To prepare a filtered list at a new place ,choose the__________ option in the Advanced Filter dialog box​

Answer 1

Answer: Step by step explanation is given below:

1. To prepare a filtered list at a new place, choose the

Advanced Filter dialog box.

2. Excel can sort data in more than one fields using the

Sort dialog box.

option of the

3.

make the comparison of data easy at different points.

then

4. Excel first sorts

blank cells.

followed by

5. The

filter is used to add more than are criterion.

Answer 2

Answer:

powerful filters such as filtering for unique records and using operators such as or.