Question

What are the two options provided in Ms- Excel for filtering data?​

Answer 1

data in your worksheet and hide parts of it from view. While it may sound a little like grouping, filtering is different because it allows you to qualify and display only the data that interests you.