Page 25 - TP_Plus_v4_Class7
P. 25

Follow these steps to get the required information:


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

                   1   Select the range of columns
                       and apply filters.

                          Place your mouse over                                                 Select the  Greater   4
                                                                                                Than option.
                      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