Available Answers

1. 1.

   Fill in the blanks with correct words.

   Formula

   Enter

   Same

   Mixed

   Concatenation

   1. The button on the Formula bar works as ______ key.
   2. $B7 is an example of _______ referencing.
   3. Joining two strings is called _________.
   4. Formula can be entered on the ________ bar on the cell.
   5. The Multiplication (*) and division (/) arithmetic operators have the _______ order of evaluation.
2. 2.

   Write T for the true statement and F for False one. Correct the false statement(s).

   1. By default, Excel creates a relative cell reference in a formula.
   2. The Cancel button present near the Formula bar works as the Enter key.
   3. The error '#####' appears if the formula contains an invalid operation.
   4. All cells in rows 5 through 9 are referred as 5.9.
   5. In the order of evaluation the addition operator (+) has higher precedence than the exponent operator (^).
3. 3.

   What is the difference between the three types of cell referencing?

4. 4.

   How will you refer to the cell in column B and row 2?

5. 5.

   What do you mean by concatenation?

6. 6.

   When would you get the erry '####' in Excel?