Question

We know there are many advantages to using filters in Excel. Are there any disadvantages? Explain.

Answer 1

Filtering is an option in Microsoft Excel that display some rows with some certain conditions and hides other rows that we don't want to display.filtering option is used on the large sets of data.there are advantage s as well as disadvantages for a filtering option in excel.

Advantages

1.There is one more option available called advance filtering which filter up to a critical range

2.we can create filter in three ways such as list values, criteria or by formats

Disadvantages

1.we cannot apply filter to multiple tables at a time which is a main drawback.

2.if we use the find option to search something in the table it will only search in the filtered table not in the original one.

3.this filter option cannot create dynamic table with auto Filter option

Filter is one of the best option if we are using Microsoft Excel daily and if we want to save a lot of time.