Exercise : Microsoft Excel MCQ Questions and Answers
Question 1
What will be the output if you format the cell containing 5436.8 as '#,##0.00′?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. 5436.80
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
Shortcut to open a document is ______ ?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Ctrl + O
Description :
No answer description available for this question. Let us discuss.
Question 3
While Finding and Replacing some data in Excel, which of the following statement is valid?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. You can Find and Replace within the sheet or workbook
Description :
No answer description available for this question. Let us discuss.
Question 4
How can you make the selected character superscripted?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Ctrl + Shift + =
Description :
No answer description available for this question. Let us discuss.
Question 5
Concatenation of text can be done using
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Ampersand ( & )
Description :
No answer description available for this question. Let us discuss.
Question 6
Which of the following Excel screen components can NOT be turned on or off?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. None of these
Description :
No answer description available for this question. Let us discuss.
Question 7
Which of the cell pointer indicates you that you can make selection?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Doctor’s symbol (Big Plus)
Description :
No answer description available for this question. Let us discuss.
Question 8
How can you increase the font size of selected text by one point every time?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. By pressing Ctrl + ]
Description :
No answer description available for this question. Let us discuss.
Question 9
What is the correct combination of key to decrease the font size of selected text?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Ctrl + Shift + <
Description :
No answer description available for this question. Let us discuss.
Question 10
A numeric value can be treated as label value if ...... precedes it.
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Apostrophe ( ‘ )
Description :
No answer description available for this question. Let us discuss.