Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 31 - 2626_South Point_C-7
P. 31

    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 get the required information:

                     Step 1:  Apply filters to the data.

                     Step 2:  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 |