COMPUTER FUNDAMENTALS

Detailed explanation-1: -On the Data tab, in the Sort & Filter group, click Filter. in the column header to display a list in which you can make filter choices. Note Depending on the type of data in the column, Microsoft Excel displays either Number Filters or Text Filters in the list.

Detailed explanation-2: -If you need a filter for something specific, basic filtering may not give you enough options. Fortunately, Excel includes several advanced filtering tools, including search, text, date, and number filtering, which can narrow your results to help find exactly what you need.

Detailed explanation-3: -On the HOME tab, click Sort & Filter, and click Filter. Click a drop-down arrow at the top of one of the columns to display its filter options. I click the drop-down arrow in the Category column. Since the column contains text I get the Text Filters options.