Page 61 - TP_Prime_v2.2_Class_6
P. 61

d.  A group of selected cells is called ___________.

                         (i)  Selection                                (ii)  Combination

                         (iii)  Cell range                             (iv)  None of these

                 2.  Write ‘T’ for true and ‘F’ for false.

                     a.  Every formula begins with a + sign.                                          ___________           FORMULAS AND FUNCTIONS IN EXCEL

                     b.  Combined reference is a type of cell reference.                              ___________

                     c.  The UPPER function is used to find the largest value in the given range.     ___________

                     d.  The LOWER function changes the given string into lowercase.                  ___________

                     e.   The LEN function returns the length of the provided string.                 ___________



                   Evaluation Time
                                                                                                                          59
                 1.  Fill in the blanks using the hints given below:

                                        Functions,   ABS(),   equal,   Dollar ($),   square root

                     a.  ___________ are predefined formulas in Excel.

                     b.  Formulas in Excel begin with the ___________ sign.

                     c.  The SQRT function returns the ___________ of the given number.

                     d.   In Mixed Referencing, you can lock either a column or a row by preceding it with a
                        ___________ symbol.

                     e.   The ___________ function returns the absolute value of a given number.

                 2.  Short answer type questions.

                     a.  What is cell reference?
                     b.  What is the use of the Text functions in Excel?

                     c.   What will be the output of =TODAY() function?

                 3.  Long answer type questions.

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

                     b.  What are rules to enter a function?
                     c.  What is the use of concatenate?
                                                                                                   21 st   #Information Literacy
                                                                                                 Century
                 4.  Competency-based/Application-based questions.                                Skills  #Critical Thinking
                       a.   Ridhi  is  trying  to  show  grade  A  if  average  of  marks  come  out  to  be  more  than

                        70 else she wishes to show grade B. Would you help her note down the functions she would
                        require to do her task.
   56   57   58   59   60   61   62   63   64   65   66