Page 24 - TP_Prime_V2.2_Class7
P. 24

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
           Prime (Ver. 2.2)-VII  have just been hidden from the display.
                            from the list. You need not to worry as the data is not lost. The unchecked rows















          22




                                        Filtering data                           Filtered data
                  To get the data back, open the filter drop-down list again and check the unchecked entries.


                     Custom Filter

                  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 the 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.
                  Step 3:  Place your mouse over the Number Filters option. A sub-menu opens.

                  Step 4:  Select the Greater Than option.
                            The Custom AutoFilter dialog box
                            appears.

                  Step 5:  Enter 80 in the criteria box and
                            click on the OK button.











                            Custom AutoFilter dialog box                         Applying custom filter
   19   20   21   22   23   24   25   26   27   28   29