Page 38 - CG_v2.1_flipBooks_class_6
P. 38

B.  Fill in the blanks using the words given below.
                                             Functions   Equal to   dollar ($)   Square root

                      1.                    are predefined formulas in Excel.

                      2.  Formulas in Excel begin with the                 sign.
                      3.  The SQRT function returns the                  of the given number.

                      4.   In mixed referencing, you can lock either a column or a row by preceding it with a
                         symbol.
                  C.  State whether these statements are true or false.

                      1.  Excel provides functions to work with text values.
                      2.  Combined reference is a type of cell reference.
                      3.  A function is a built-in formula in Excel.

                  D.  Answer the following questions:
                      1.  What is the difference between NOW() and TODAY() functions?





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




                      3.  What are the rules for using a function?









                       FUN ZONE                                                          Technology Literacy
                                                                                         Critical Thinking

                       Solve the crossword using the clues.

                     Across:
                     2.  Predefined formula in Excel

                     4.   Function used to display current date

                     5.   Cell address that is to be used in a calculation

                     6.   Function used to add values in cells

                     Down:

                     1.  Function used to multiply values in cells
                     2.   Mathematical expressions that are used perform calculations

                     3.   Function used to convert text string into lowercase



                       36    Computer Genius (V2.1)-VI
   33   34   35   36   37   38   39   40   41   42   43