Question

write the steps for filtering the
data in Excel worksheet ​

Answer 1

steps----

1) Create a table , make sure that ur data have column heading to specify the data below that .

2) Select all the data u wish to filter .Click and drag to select all of the cells. You wish to be included in the filter.

3) Activate Auto Filter , y to the Dta tab , then press Filter.

4) select filter criteria.

plzz mark me as brainlist nd follow me❤❤❤❤❤❤❤❤

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.