Exercise : Microsoft Excel MCQ Questions and Answers
Question 1
To move the cursor page to page of document
A. |
B. |
C. |
D. |
Correct Answer : C. Both of I and II
Description :
No answer description available for this question. Let us discuss.
Question 2
In MS-Excel it is acceptable to let long text flow into adjacent cells on a worksheet when
A. |
B. |
C. |
D. |
Correct Answer : C. II. No data will be entered in the adjacent cells
Description :
No answer description available for this question. Let us discuss.
Question 3
In MS-Excel the drag and drop method of copying or moving
A. |
B. |
C. |
D. |
Correct Answer : A. None of these
Description :
No answer description available for this question. Let us discuss.
Question 4
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A. |
B. |
C. |
D. |
Correct Answer : D. Apply Conditional Formatting command on Format menu
Description :
No answer description available for this question. Let us discuss.
Question 5
You need to jump to the next column breaking current column right at the cursor position. How can you break column?
A. |
B. |
C. |
D. |
Correct Answer : D. Break command from Insert menu
Description :
No answer description available for this question. Let us discuss.
Question 6
Long text can be broken down into many lines within a cell. You can do this through
A. |
B. |
C. |
D. |
Correct Answer : B. Wrap Text in Format >> Cells
Description :
No answer description available for this question. Let us discuss.
Question 7
By which shortcut we can increase the font size of the selected text?
A. |
B. |
C. |
D. |
Correct Answer : C. Ctrl + Shift + >
Description :
No answer description available for this question. Let us discuss.
Question 8
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
A. |
B. |
C. |
D. |
Correct Answer : B. MOD ( )
Description :
No answer description available for this question. Let us discuss.
Question 9
How can you remove borders applied in cells?
A. |
B. |
C. |
D. |
Correct Answer : A. Both of I and II
Description :
No answer description available for this question. Let us discuss.
Question 10
Shortcut to quit Microsoft Word, Powerpoint, Access, Excel etc is ______?
A. |
B. |
C. |
D. |
Correct Answer : C. Alt + F4
Description :
No answer description available for this question. Let us discuss.