Question

write the steps for filtering the data in Excel worksheet ​

Answer 1

press ctrl+A

right click

select filter

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.