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

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