Page 24 - TP_Plus_v4_Class7
P. 24
FILTERING DATA
You must have studied about filtration process which is used to separate unwanted material from a
mixture. Filtering data in Excel allows you to display only the data that meets certain criteria, hiding
rows that don't match the specified conditions. To apply filters, follow these steps:
2 Click on the Sort & Filter
command.
Click on
the Filter 3
option.
Select the range
1 of columns to
be filtered.
You will notice that small arrows appear in front of all the column headers.
Click on the arrow in
front of the header
4 Marks Obtained in
Second Term.
Click some of the
5 check boxes to
uncheck them.
6
Click on the OK button.
To get the data back, open the filter drop-down list again and check the unchecked entries.
Excel also allows you to use custom filter. Suppose, you want to know the names of the students who
have scored more than 80 marks in second term.
22 Plus (Ver. 4.0)-VII

