Page 26 - C_GPT _V4 _class_7
P. 26

To apply filters, follow these steps:

                                                                      2   Click on the Sort
                                                                          & Filter button.






                                                                                                    Click on the   3
                                                                                                    Filter option.
                     Select  the
                     range   of

                1    columns to
                     be filtered.













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

                  4   Click on the arrow in front of the header
                      Marks Obtained in Second Term.





























                     5   Click some of the check      Click on the   6
                         boxes to uncheck them.       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 a custom filter. Suppose you want to know the names of the students who
              have scored more than 80 marks in the second term.






                        CodeGPT (Ver. 4.0)-VII
                 24
   21   22   23   24   25   26   27   28   29   30   31