Question

what is the use of multiple filters in MS Excel​

Answer 1

Answer:

When you apply the Filter function, after filtering one column, the next columns will be only filtered based on the result of the previous filtered column. It means that only AND criteria can be applied to more than one column.