Available Answers

1. 1.

   Fill in the blanks with the correct words.

   Absolute, Clicking, Enter, HOME, Relative

   1. The check button in the Formula bar works as the _____________ key.
   2. $A$ is an example of ____________ cell referencing.
   3. The AutoSum button is protect in the Editing group on the _____________ tab.
   4. Pointing is a method of adding a cell reference to a formula by ______________ the cell.
   5. By default, Excel creates ____________ cell referencing.
2. 2.

   Write T for the true statement and False one. Correct the false statements.

   1. If you have written a formula in a cell, you normally see the formula in the Formula Bar when the cell is selected.
   2. The symbol for exponent operator is *
   3. The multiplication and division arithmetic operators have the same precedence.
   4. The AVG function is used to find the average value of set of values.
   5. The ampersand operator is used for concatenation of text values.
3. 3.

   Choose the correct option.

   1. A formula in Excel 2013 always starts with a/an ____________ sign.
      1. $
      2. &
      3. =
      4. +
   2. What will be the output if you type '= (5+3) ∧ 2' in a cell?
      1. 8
      2. 16
      3. 61
      4. 64
   3. $B4 represents which type of referencing?
      1. Relative
      2. Absolute
      3. Mixed
      4. None of these
   4. Which function is used to find the maximum value in a set of values?
      1. Maximum
      2. Max
      3. Highest
      4. Top
   5. Cell B1 has the formula = A1 * SC$1' and it is copied to cell B2. What will be the formula in B2?
      1. A2 * $C$1
      2. A1 * $C$1
      3. A2 * $C$2
      4. A1 * $C$1
4. 4.

   What are the three types of cell referencing?

5. 5.

   What is circular reference? Explain with an example.

6. 6.

   What are the two places where AutoSum button is available?