Question

1.Write down steps to filter data in excel​

Answer 1

Answer:

answer as follows

Explanation:

To filter data:

Begin with a worksheet that identifies each column using a header row. ...

Select the Data tab, then locate the Sort & Filter group.

Click the Filter command. ...

Drop-down arrows will appear in the header of each column.

Click the drop-down arrow for the column you want to filter. ...

The Filter menu appears.