Question

B. Fill in the blanks option in the To prepare a filtered list at a new place, choose the Advanced Filter dialog box.​

Answer 1

Explanation:

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

Advanced Filter dialog box.

option in the

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