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
   34   35   36   37   38   39   40   41   42   43   44