Page 27 - Trackpad_V1_Book 7_Flipbook
P. 27

b.    Chirag wants to see the names of those people from a list who have the same age as him.
                          Which feature can he use for this?
                          ____________________________________________________________________________



                    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 price and also calculate total amount by using SUM function.
                         (b)  Save the file with the name ‘Stationery'.
                          Enter the following data in Excel:








                         Now use the Average function to calculate the average sales of each book.

                          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        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  25
   22   23   24   25   26   27   28   29   30   31   32