Page 53 - TP_Plus_v4_Class6
P. 53

Scratch Your Brain.                                                      Century   #Critical Thinking
                                                                                                   21 st
                                                                                                   Skills  #Communication
                        1. Solve the crossword using the clues.

                              Across:
                            3.   Symbols that specify what                      1              2
                              calculations to be performed
                                                                                                       4
                            5.   Function used to convert           3           E              O       S
                              text string into upper case

                            7.   Numbers or text that do not
                              change
                                                             5 U                R              Y       6
                            8.   Function used to convert
                              text string into lower case

                            9.   Function used to multiply                  7 C                        N
                              values in cells
                                                                 8      O           R
                           Down:

                            1.   Cell address that is to be
                              used in a  calculation                                        9          O              T

                            2.   Function used to display
                              current date
                            4.   Function used to add values in cells

                            6.   Predefined formula in Excel

                        2.   Competency-based/Application-based questions:

                            a.   Siya has made a spreadsheet of the marks obtained in different subjects by the students in her
                              class. She has made some changes to the marks of some students. Now she wants the total number
                              of marks for those students to be automatically updated. Which function should she use to do so?
                            b.   Your friend Alisha was using Excel and wants to add the date and time of her daily visit to the local
                              church. She doesn’t know how to do this. Tell her the appropriate function she can use to do so.






                              Scan the QR Code and attempt the quiz.







                          A Better Me!                                                     Century   #Initiative
                                                                                              21 st
                                                                                             Skills  #Leadership & Responsibility
                          Your neighbour  has been preparing a list of grocery items with  their prices. She  has been
                          manually calculating  the total amount. Do you  think  you  should  help  people  whenever  you  see
                          an opportunity?







                                                                               #Charts, Formulas and Functions in Excel  51
   48   49   50   51   52   53   54   55   56   57   58