Question

Give example for filtering in MS-Excel

Answer 1

Answer:

The Exel Autofilter. The basic Exel filter (also known as the Exel Autofilter) allows you to view specific rows in an Exel Spreadsheet while hiding the added to the header row of a spreadsheet, a drop-down menu appears in each cell of the header row.

Answer 2

${\huge\boxed { \sf{ \red{Answer}}}}$

• Select the data you want to filter. On the Home tab, click Format as Table, and then pick Format as Table.

• In the Create Table dialog box, you can choose whether your table has headers.

• Click OK.

• To apply a filter, click the arrow in the column header, and pick a filter option.