Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 57 - 2620_Birla Open Mind C-6
P. 57

    E.    Brain Boost.                                                              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 returns the sum of values
                                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.

                              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  55

| 52 53 54 55 56 57 58 59 60 61 62 |