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
   19   20   21   22   23   24   25   26   27   28   29