B. Fill in the blanks.
1. To prepare a filtered list at a new place, choose the
Advanced Filter dialog box.
option of the
2.
Excel can sort data in more than one fields using the
Sort dialog box.
3.
make the comparison of data easy at different points.
followed by
then
4. Excel first sorts
blank cells.
5. The
filter is used to add more than are criterion.
Answers
Answer:
The tutorial explains the basics of Excel's Advanced Filter and shows how to use it to find the records that meet one or more complex criteria.
If you had a chance to read our previous tutorial, you know that Excel Filter provides a variety of options for different data types. Those inbuilt filtering options for text, numbers, and dates can handle many scenarios. Many, but not all! When a regular AutoFilter can't do what you want, use the Advanced Filter tool and configure the criteria exactly suited to your needs.
Excel's Advanced Filter is really helpful when it comes to finding data that meets two or more complex criteria such as extracting matches and differences between two columns, filtering rows that match items in another list, finding exact matches including uppercase and lowercase characters, and more.
Advanced Filter is available in all versions of Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003. Please click on the links below to learn more.