Page 24 - Plus V4 with Adobe class 7
P. 24

FILTERING DATA


        You must have studied about filtration process which is used to separate unwanted material from
        a mixture. Excel also allows you to filter unwanted data from a set of data. To apply filters, follow
        these steps:

                                                           2  Click on the Sort & Filter
                                                              command.




                                                                                                Click   on
                                                                                                the  Filter   3
                                                                                                options.


               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. Follow  these  steps  to  get  the  required
        information:




            22  Plus (Ver. 4.0)-VII
   19   20   21   22   23   24   25   26   27   28   29