Available Answers

1. 1.

   Fill in the Blanks.

   1. The F5 function key is the ______________ key for moving quickly to a particular cell in a different part of the worksheet.
   2. You can use the ______________ to quickly locate and select specific cells or ranges by entering their names or their cell references.
   3. You can compare two values with ______________ operators.
   4. ______________ are predefined formulas, that perform calculations by using specific values, called ______________.
   5. There are four types of operators: ______________ , ______________ , ______________ and ______________.
2. 2.

   Write True or False.

   1. Formulas are equations, that perform calculations on values in your worksheet.
   2. The dollar sign tells excel, that the succeeding characters constitute a formula.
   3. The F5 function key is the "Goto" key.
   4. Operators specify the type of calculation, that you want to perform on the elements of a formula.
   5. There are six types of operators.
3. 3.

   Multiple Choice Questions (MCQs).

   1. A _____________ cell reference in a formula is based on the relative position of the cell, that contains the formula, and the references cell.
      1. relative
      2. relation
      3. reverse
   2. A _____________ reference has either an absolute column and relative row or absolute row and relative column.
      1. absolute
      2. relative
      3. mixed
   3. _____________ are predefined formulas, that perform calculations by using specific values, called arguments.
      1. Sum
      2. Max
      3. Functions
   4. A _____________ is a value that is not calculated.
      1. formula
      2. function
      3. constant
   5. _____________ specify the type of calculation, that you want to perform on the elements of a formula.
      1. Function
      2. Operators
      3. Formula
4. 4.

   Make a list of the arrow keys, to move around in a worksheet.

5. 5.

   Write the steps to move or copy a cell.

6. 6.

   What is a formula? What are the parts of a formula? Explain them.