Page 25 - Plus V4 with Adobe class 7
P. 25

2   Click  on  the  Marks Obtained  in
                                       Second Term header.
               1
                   Apply filters to the data.

                                                                                          Select the  Greater
                    Place your mouse over                                                 Than option.         4
                3   the  Number Filters
                    option.







                       5   Enter 80 in the
                           criteria box.                                                  Click on the   6
                                                                                          OK button.




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

            Removing Filters


            The filters once applied can be easily removed. Click anywhere in the worksheet and repeat steps to
            apply filters. You will notice that the filter arrows in front of column headers disappear and the hidden
            rows also reappear.


                     Double Tap                                                        Century   #Critical thinking
                                                                                         21 st
                                                                                         Skills
                   Tick ( ) the correct statements.

                   1.  Sorting of data means to organise the data in ascending or descending order.

                   2.  Excel allows you to sort only one column.
                   3.  The filters once applied cannot be easily removed.

                   4.  Excel allows you to filter unwanted data from a set of data.




                      Art Integration Learning

                      #Sports

              Make a list of one-day matches that have been held in the last two years. Consider any of the five countries
              that have participated, including India. Make separate columns for the country name, runs, win, and loss.
              Calculate the total number of matches and total number of runs. Find how many matches India won & how
              many lost.


                                                                                                       #Lab Activity




                                                                                    #Advanced Features of Excel  23
   20   21   22   23   24   25   26   27   28   29   30