Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 24 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 24

    LAB ACTIVITY                                                                      Subject Enrichment

                         Visit your computer lab and perform the following actions:
                              Create a list of the stationery items.
                            (a)  Sort the list by name.
                            (b)  Save the file with the name 'Stationery'.
                             Enter the following data in Excel:

                            Now filter the records that have same values in the month of March.
                             Following is a list of names entered in Excel:
                            (a)   Arrange the names in alphabetical order and use the
                                Filter option to view only the names of all the boys.
                            (b)   Add another filter to only see the boys whose hometown
                                is Roorkee.

                              COding Zone       COding Zone    {}      =     COding Zone Computational Thinking
                                    {C ding z ne}
                                                                                                                 []
                                                                                                        COding Zone
                                                                              </>
                         Fill the missing input values in the following questions:
                         a.   45                 135

                         b.             5        25

                         c.   36                 14        132

                           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.

                                                                                             Advanced Features of Excel  23

| 19 20 21 22 23 24 25 26 27 28 29 |