Question

Explain the use of filter feature in MS-Excel.

Answer 1

Answer:

The Excel FILTER function filters a range of data based on supplied criteria, and extracts matching records. The Excel SORT function sorts the contents of a range or array in ascending or descending order. Values can be sorted by one or more columns. ... The range or array used to sort does not need to appear in results.

Mark me as brainliest

Answer 2

Answer:

here is the answer

Explanation:

The Excel FILTER function filters a range of data based on supplied criteria, and extracts matching records. The Excel SORT function sorts the contents of a range or array in ascending or descending order. Values can be sorted by one or more columns. ... The range or array used to sort does not need to appear in results.