Page 65 - modular4.0
P. 65
Chapter Profile
FILTERING DATA
You must have studied about filtration process which is used to separate unwanted material from a
mixture. Excel also provides you with the ability to filter unwanted data from a set of data.
Follow the given steps to apply filter:
2 Click on the
Sort & Filter
command.
3 Select Filter
options.
1 Select the range of columns to be filtered.
4 Click on the
arrow in front
of the header
Marks Obtained
in Second Term.
5 Click some of
the check boxes
to uncheck them.
6 Click on the OK button.
Now, suppose you want to see rows of students who scored more than 80 in Marks Obtained
in Second Term. Number Filters in Excel allow you to filter numeric data in a column based on
conditions like greater than, less than, or equal to a specific number. This is useful for large datasets
as it eliminates the need to manually check and uncheck values.
Follow the given steps to use Number Filters option:
1 Select the range of columns 2 Click on the
and apply filters. Marks Obtained
in Second Term
header.
3 Place your mouse over
the Number Filters option. 4 Select the Greater
Than option.
Excel as Database 63

