Page 49 - Digicode_AI_class_7
P. 49

Suppose, you want to know the names of the students who have scored more than 80 marks.
            Follow these steps to get the required information:


                                                1  Click on Marks Obtained
                                                column header.












                                                                                  2  Place your mouse
                                                                                  over Number Filters
                                                                                  option and select the
                                                                                  Greater Than option.


























                           3  Enter 80 in the criteria box.


















                            4  Click on the OK button.


            Notice that only the details of the students who have obtained marks greater than 80 are displayed
            and the remaining rows get hidden.





                                                                        Advanced Features of Excel 2016   47
   44   45   46   47   48   49   50   51   52   53   54