Page 39 - Computer_Genius_v2.1_C7_flipbook
P. 39
Filtering Data
You must have studied about filtration process which is used to separate unwanted material from a
mixture. Excel also provides you to filter unwanted data from a set of data.
To apply filters, follow the given steps:
2 Click Sort & Filter command.
3 Click Filter from
the drop-down list.
1 Select the
range of columns
to be filtered.
4 Click on the arrow in front of the header
Marks Obtained to open a drop-down list.
5 Click some of
the checkboxes
to uncheck them.
6 Click on the OK button.
You will notice that the rows of unchecked data are removed from the list. You need not worry as the
data is not lost. Notice the row headings. Some of the row headings are missing. The unchecked rows
have just been hidden from the display. To get the data back, open the filter list again and check the
unchecked entries.
Advanced Features of Excel 2016 37

