What do you understand by data filtering? How types of filters are the

1.	What do you understand by data filtering? How types of filters are there in excel?
Answer» Filtering data in MS Excel refers to\xa0displaying only the rows that meet certain conditions. (The other rows gets hidden.)Table Name Store Data\tProduct NameSizePrice RsShoe A35350\xa0Shoe B36360Shoe C36370Shoe D35380\tfor example - Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this.There are two major types of data filters in Excel:\xa0text and number.Text filters can help you search for words and symbols.Number filters can do the same as text filters but can also use a range of values to refine a set of data.

Discussion