Exercise : Microsoft Excel MCQ Questions and Answers
Question 1
The Name box on to the left of formula bar
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. shows the name of cell or range currently working on
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
Which Chart can be created in Excel?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. All of these
Description :
No answer description available for this question. Let us discuss.
Question 3
When a row of data is to be converted into columns
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Description :
No answer description available for this question. Let us discuss.
Question 4
Microsoft Excel is a powerful ...........
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Spreadsheet package
Description :
No answer description available for this question. Let us discuss.
Question 5
What is the short cut key to open Font dialog box?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Ctrl + D
Description :
No answer description available for this question. Let us discuss.
Question 6
You can move a sheet from one workbook into new book by
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
Description :
No answer description available for this question. Let us discuss.
Question 7
Which of the following function key activates the speller?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. F7
Description :
No answer description available for this question. Let us discuss.
Question 8
You can use the formula pallette to
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. create and edit formula containing functions
Description :
No answer description available for this question. Let us discuss.
Question 9
In MS-Excel default header for a worksheet is
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. None of these
Description :
No answer description available for this question. Let us discuss.
Question 10
Which of the following you can paste selectively using Paste Special command?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. All of these
Description :
No answer description available for this question. Let us discuss.