Question

Computer science
How is Advanced filter different from filter ​

Answer 1

While the regular data filter will filter the existing dataset, you can use Excel advanced filter to extract the data set to some other location as well. Excel Advanced Filter allows you to use complex criteria.

Excel Advanced Filter is one of the most underrated and under-utilized features that I have come across.

If you work with Excel, I am sure you have used (or at least heard about the regular excel filter). It quickly filters a data set based on selection, specified text, number or other such criteria.

Answer 2

Question:-

How is advance filter different from filter?

Answer:-

● Here are some differences between the regular filter and Advanced filter:

☑ While the regular data filter will filter the existing dataset, you can use Excel advanced filter to extract the data set to some other location as well......✍

☑ Excel Advanced Filter allows you to use complex criteria......✍

☑ any criteria true make sure that there is at least one blank row between the criteria values and the list range. Click a cell in the list range. Using the example, click any cell in the range A6:C10. On the Data tab, in the Sort & Filter group, click Advanced......✍

☑ Hope it helps!!

☑ Mark me as brainliest...