Page 28 - TrackpadV2.1_Class8
P. 28

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





                                                                                                 21 st
                      LAB ACTIVITY                                                            Century   #Technology Literacy
                                                                                                Skills
                      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 #Critical Thinking
                                 {C ding z ne}
                                                                                               21 st
                                                                                                              []
                                                                                            Century
                                                                                              Skills
                                                                          </>
                                                                                                     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.




                   26   Trackpad (V2.1)-VII
   23   24   25   26   27   28   29   30   31   32   33