Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 26 - 2610_Springdales_C-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.

                            Premium Edition-VII
                     24

| 21 22 23 24 25 26 27 28 29 30 31 |