Question

Give examples for filtering in MS-Excel

Answer 1

heya mate...

Answer:

Select the entire data set (including the headers).

Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q). ...

In the Advanced Filter dialog box, use the following details: Action: Select the 'Copy to another location' option. ...

Click OK.

hope it helps u ❤️

Answer 2

HEY MATE....

ANSWER:

1. On the Data tab, in the Sort & Filter group, click Filter.

2. The Sort and Filter group on the Data tab

3. Click the arrow Filter drop-down arrow 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.

HOPE IT HELPS....