Question

what is data filtering? explain the way to extract data using custom auto filter​

Answer 1

Explanation:

Data filtering is the process of choosing a smaller part of your data set and using that subset for viewing or analysis. Filtering is generally (but not always) temporary – the complete data set is kept, but only part of it is used for the calculation. ... Calculate results for particular groups of interest.

Answer 2

$\huge{\boxed{\red{\bf{Data\: filtering}}}}$

Data filtering is the process of choosing a smaller part of your data set and using that subset for viewing or analysis. Filtering is generally (but not always) temporary – the complete data set is kept, but only part of it is used for the calculation. ... Calculate results for particular groups of interest.

$\huge\underline\mathfrak\purple{Steps}$

To indicate which field you want to use, open the filtering drop-down list for that field to display the table menu, select Text Filters, and then select a filtering option. When you do this, Excel displays the Custom AutoFilter dialog box

${\huge{\fcolorbox{black}{WHITE}{♡HAN JU HUI♡}}}$