Page 38 - Digicode_AI_class_6
P. 38

D.  Answer the following questions:
                1.  What is a cell reference?



                2.  What is the use of the LEN function? Explain with an example.





                3.  What are the rules for using a function?






                                                                                   Technology Literacy
                                                                                   Critical Thinking

                Solve the crossword using the clues.
              Across:
              3.    Symbols that specify calculations to be performed
              5.   Function used to convert text string into uppercase
              7.   Number or text that does not change
              8.   Function used to convert text string into lowercase
              9.  Function used to multiply values in cells

              Down:
                                                                  1               2
              1.   Cell address that is to be used in a calculation
              2.   Function used to display current date                                 4
              4.   Function used to add values in cells  3        E              O       S
              6.  Predefined formula in Excel


                                               5                  R







                                                                                         6




                                                               7 C                       N

                                                   8      O       E




                                                                               9         O







                 36    DigiCode AI-VI
   33   34   35   36   37   38   39   40   41   42   43