Page 34 - TP_V5.1_C7_fb
P. 34

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 Mathematical functions? Write any two functions.

                      ______________________________________________________________________________________
                      ______________________________________________________________________________________

                     b.  What is the use of IF(condition, value1, value2) function? Explain with example.
                      ______________________________________________________________________________________

                      ______________________________________________________________________________________

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

                      ______________________________________________________________________________________
                      ______________________________________________________________________________________

                     d.  What are the rules to enter a function?
                      ______________________________________________________________________________________

                      ______________________________________________________________________________________
                     e.  Explain the meaning of #NAME?, #REF! and #NUM! errors in Excel.
                      ______________________________________________________________________________________

                      ______________________________________________________________________________________

                      ______________________________________________________________________________________
                      ______________________________________________________________________________________

                  4.  Define the following functions:

                     a.  INT(number)  __________________________________________________________________________

                     b.  TODAY()     __________________________________________________________________________

                     c.  LEN()       __________________________________________________________________________

                     d.  SQRT        __________________________________________________________________________

                     e.  MOD         __________________________________________________________________________
                  5.  Differentiate between the following:

                     LEFT(text, num_chars) and RIGHT(text, num_chars)                           MAX(range) and MIN(range)
                     _____________________________________________                __________________________________
                     _____________________________________________                __________________________________









                   32   Premium Edition-VII
   29   30   31   32   33   34   35   36   37   38   39