Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 30 - 2633 Trackpad Pro V5.1 Class 7
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   Premium Edition-VII

| 25 26 27 28 29 30 31 32 33 34 35 |