MS EXCEL multiple choice questions and answers on MS EXCEL MCQ questions quiz on MS EXCEL objective questions.

MS EXCEL MCQ Questions and Answers Quiz

1. What value will display if the formula = “$55.00″+5 is entered into a cell?

  1. 60
  2. “$55.00″+5
  3. $60.00
  4. 2

2. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?

  1. 5436.80
  2. 5436.80
  3. 6.8
  4. 2

3. The cell reference for cell range of G2 to M12 is ……………………………..

  1. G2;M12
  2. G2:M12
  3. G2-M12
  4. 3

4. Formulas in Excel start with

  1. %
  2. =
  3. +
  4. 3

5. In the formula, which symbol specifies the fixed columns or rows ?

  1. %
  2. $
  3. All of the above
  4. 3

6. What is the symbol for multiplying?

  1. /
  2. !
  3. *
  4. 4

7. How to specify cell range from A9 to A99 in Excel?

  1. (A9 to A99)
  2. (A9 : A99)
  3. (A9 – A99)
  4. 3

8. What is the symbol for dividing?

  1. %
  2. &
  3. #
  4. 1

9. What should be add before a fraction to avoid entering it as a date ?

  1. Zero
  2. Space
  3. None of the above
  4. 3

10. Which of the following is correct ?

  1. =POWER(2^3)
  2. 8
  3. None of the above
  4. 3
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer