Page 30 - trackpad v5.1 class 7 flipbook
P. 30

Use the sorting feature to arrange the names in alphabetical order i.e., in ascending order.

                            Then again use the sorting feature to arrange the ages from smallest to largest.
                            Use the same data from the above part to use the filter feature on.

                            Use the Filter option to view only the names of all the boys.
                            Add another filter to only see the boys whose hometown is Roorkee.

                      b.   Create an Excel worksheet of a list of ten of your friends and their favourite movies. Also
                         make a column telling how many times they have watched that movie approximately. When
                         the data is entered, sort it alphabetically. Use the IF function to check how many of them have
                         watched their favourite movies more than 5 times. Then use the filter feature to only display
                         the names of the friends who have watched their favourite movies less than 5 times.







                           COding Zone       COding Zone    {}      =     COding Zone
                                 {C ding z ne}
                                                                                           #Technology Literacy
                                                                                        21 st
                                                                                     Century
                                                                                           #Productivity & Accountability
                                                                                       Skills
                                                                           </>
                      1.   Write a formula using the SUM() function to calculate the total of values in cells D3 through
                         D10.
                      2.   Create an IF() function formula to display “Eligible” if a value in cell E1 is greater than or equal
                         to 18, otherwise display “Not Eligible”.
                      3.   Sort a dataset by two columns: first by ‘Grade’ in ascending order, and then by ‘Name’ in
                         alphabetical order.






                        CAREER HERE
                  People who are experts in Microsoft Excel may pursue their careers as Data Analysts.





                     FOR THE TEACHER
                    1.  Demonstrate the concepts of sorting and filtering to the students in detail.
                    2.  Explain the procedure of conditional formatting in detail.





















                   28   Pro (V5.1)-VII
   25   26   27   28   29   30   31   32   33   34   35