Question

write the steps for filtering the data in excel worksheet

Answer 1

Steps:

1)-Create a table. Make sure that your data have column headings to specify the data below it. ...

2)-Select all the data you wish to filter. 3)-Click and drag to select all of the cells you wish to be included in the filter. ...

Activate AutoFilter. Go to the “Data” tab, then press “Filter”. ...

)4-Select filter criteria.

Answer 2

Explanation:

• Click on Data tab
• Click on filter option in sort and filter group.
• Drop-down arrows are added in front of the headings of all the selected columns.
• Click on the drop-down arrow present on the column heading country.
• A drop-down menu opens.
• By default, all the country options in the filter drop down menu are checked, that is, there is a tick in all the boxes. Untick all the boxes except India.
• Click on OK.

Hope it helps