Exercise : Microsoft Excel MCQ Questions and Answers
Question 1
Where can you change automatic or manual calculation mode in Excel?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. II. Go to Tools >> Options >> Calculation and mark the corresponding radio button
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. F9
Description :
No answer description available for this question. Let us discuss.
Question 3
By which shortcut we can change the size of the font?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Ctrl + Shift + P
Description :
No answer description available for this question. Let us discuss.
Question 4
MS-Excel is similar to which of the following accounting worksheets
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. III. Spreadsheets
Description :
No answer description available for this question. Let us discuss.
Question 5
Which menu option can be used to split windows into two?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Window -> Split
Description :
No answer description available for this question. Let us discuss.
Question 6
To move the cursor page to page of document
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Both of I and II
Description :
No answer description available for this question. Let us discuss.
Question 7
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. F11
Description :
No answer description available for this question. Let us discuss.
Question 8
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 9
Which tool you will use to join some cells and place the content at the middle of joined cell?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Click on Merge and Center tool on formatting toolbar
Description :
No answer description available for this question. Let us discuss.
Question 10
The command Edit >> Fill Across Worksheet is active only when
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. When many sheets are selected
Description :
No answer description available for this question. Let us discuss.