Page 31 - TP_Pluse_V2.2_Class_7
P. 31

Step 2:   Click on the Sort & Filter command from Editing group under Home tab. A drop-down list
                         appears.

                 Step 3:  Click on the Filter option from the drop-down list.

























                                                              Using Filter
                         You will notice that small arrows appear in front of all the column headers.

                 Step 4:   Click on the arrow in front of the header Marks
                         Obtained  in Second  Term. A drop-down list
                         appears.  You will notice  that  all the  entries  in

                         the  column  are present  in the  list  with small
                         checkboxes  in  the  beginning.  Click  some  of  the
                         checkboxes to uncheck them.

                 Step 5:   Click on the OK button. You will notice that the
                         rows of unchecked  data  are removed  from the
                         list. You need not to worry as the data is not lost.
                         The unchecked rows have just been hidden from
                         the display.                                                     Filtering data













                                                               Filtered data
                 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 apply filters to the data.
                 Step 1:   Click on the Marks Obtained in Second Term header to open the filter drop-down list.



                                                                                        Advanced Features of Excel  29
   26   27   28   29   30   31   32   33   34   35   36