Page 15 - 2403_Trackpad_V5.1_C6_Fb
P. 15

e.  Which one of the following cell references can be included in relative reference?
                        (i)  A3                                     (ii)  $A$4

                       (iii)  A$1                                   (iv)  SD6
                 2.  Fill in the blanks using the words from the help box.

                                     mouse, shift key, dollar($), True or False, Label, equal to

                    a.  We cannot do mathematical calculations on __________.
                    b.  A formula must always begin with an/a __________ sign.

                    c.  We can select a range by using the __________ and by using the __________.
                    d.  When two values are compared by using operators, the result is either __________.

                    e.   In Mixed Referencing, you can lock either a column or a row by preceding it with a __________ symbol.
                 3.  Think and answer.

                    a.  What are formulas in Excel?
                     ______________________________________________________________________________________

                     ______________________________________________________________________________________
                    b.  What is operator precedence?
                     ______________________________________________________________________________________

                     ______________________________________________________________________________________

                    c.  What are the ways to enter a formula?
                     ______________________________________________________________________________________

                     ______________________________________________________________________________________

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

                     ______________________________________________________________________________________
 1.  Tick ( ) the correct option.
                     ______________________________________________________________________________________
    a.  Which of the following is left-aligned by default?

    (i)  Values      (ii)  Labels       ______________________________________________________________________________________
    (iii)  Formulas      (iv)  None of these
                    e.  What is the way to make a cell reference as a mixed reference?
    b.  Which of the following is an arithmetic operator?
                     ______________________________________________________________________________________
    (i)  ^      (ii)  =
    (iii)  :      (iv)  <>       ______________________________________________________________________________________
    c.  The cell address in the formula is known as __________ .      ______________________________________________________________________________________

    (i)  Range       (ii)  Cell Reference
    (iii)  Mixed Reference        (iv)  None of these   4.  Define the following functions:
    d.  A group of selected cells is called __________ .     a.  Arithmetic operators   ________________________________________________________________

    (i)  Selection      (ii)  Combination       ______________________________________________________________________________________
    (iii)  Cell range      (iv)  None of these



                                                                                             Formulas in Excel 2021  13
   10   11   12   13   14   15   16   17   18   19   20