Page 81 - IT-802_class_12
P. 81
2 Click on Female from the drop-down menu, and then press OK. A new sheet is displayed that contains all the
names of all female students, and as can be seen, the drop-down in the Gender column where the filter is applied
is coloured blue.
We can apply filters to other columns also. Consider filtering the data in the above example. Let’s find the data
that shows a female getting 98 marks.
3 Click on the drop-down in the the Marks column and select 98 from the drop-down. The new data output is
shown as:
3
Removing AutoFilter
To remove the AutoFilter, perform the following steps:
1 Select the cells as selected in the filter that has been applied.
2 Click on the Data menu.
3 Select Remove Filter from the Filter submenu. The filters will be removed.
ICT Skills-IV 79

