Page 58 - KEC Khaitan C6 Flipbook
P. 58

LAB ACTIVITY                                                          Century   #Technology Literacy
                                                                                              21 st
                                                                                             Skills
                      Perform the following tasks in Excel 2021.

                      a.   Following is a list of names entered in Excel.
                         Create  the worksheet  then use different
                         features of Excel as instructed.

                             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.






                     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.










                   56   Premium Edition-VI
   53   54   55   56   57   58   59   60   61   62   63