Page 33 - Trackpad_V1_Book 6_Flipbook
P. 33

c.   __________ is used in a formula to denote a specific cell.
                     d.   A __________ is a predefined formula in Excel.

                     e.   The __________ function is used to get the length of the string.

                 3.  Think and answer.
                     a.   What are formulas in Excel?

                          ___________________________________________________________________________________
                     b.   What is operator precedence?

                          ___________________________________________________________________________________

                     c.   What is the use of the CONCATENATE() function? Explain with an example.
                          ___________________________________________________________________________________

                          ___________________________________________________________________________________
                     d.   What is cell range? How can you select a cell range by using the mouse?

                          ___________________________________________________________________________________

                          ___________________________________________________________________________________
                     e.   Explain the meaning of #NAME?, #REF! and #NUM! errors in Excel. Also, write a tip to resolve them.

                          ___________________________________________________________________________________
                          ___________________________________________________________________________________

                          ___________________________________________________________________________________

                 4.  Define the following functions:

                     a.   MAX()     _________________________________________________________________________

                     b.   TODAY()   _________________________________________________________________________
                     c.   LEN()     _________________________________________________________________________


                 5.  Differentiate between the following:
                     a.   Relative Cell Referencing                          Absolute Cell Referencing
                          _____________________________                      _____________________________
                          _____________________________                      _____________________________

                     b.   Comparison Operators                               Reference Operators
                          _____________________________                      _____________________________

                          _____________________________                      _____________________________

                 6.  Application based question:                                                    Experiential Learning
                       Alisha was using Excel and encountered an error that displayed ‘#Div/0!’. She doesn’t know
                     about this error. Tell her the meaning of this error and also give a tip to resolve this.

                          ___________________________________________________________________________________




                                                                                 Formulas and Functions in Excel 2010  31
   28   29   30   31   32   33   34   35   36   37   38