Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 37 - 2632_CodeMind
P. 37

    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?

                                                                                             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    Premium Edition-VI

| 32 33 34 35 36 37 38 39 40 41 42 |