Home
Home >> Computer>> Softwares>> MS Office>> Microsoft Excel

Microsoft Excel MCQ Question with Answer

Microsoft Excel MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Download Microsoft Excel MCQ Question Answer PDF

Try Microsoft Excel Mock Test

Question No : 43
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

F8
F9
F10
F11
View Answer   Discuss

Question No : 44
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
View Answer   Discuss

Question No : 45
Where can you change automatic or manual calculation mode in Excel?

Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
View Answer   Discuss

Question No : 46
How can you show or hide the gridlines in Excel Worksheet?

Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
View Answer   Discuss

Question No : 47
Which of the following Excel screen components can NOT be turned on or off?

Formula Bar
Status Bar
Tool Bar
None of above
View Answer   Discuss

Question No : 48
Which of the following option is not available in Paste Special dialog box?

Add
Subtract
Divide
SQRT
View Answer   Discuss

Question No : 49
Which command will you choose to convert a column of data into row?

Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
View Answer   Discuss

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Link
MS Office set 1 30 Start
MS Office set 2 30 Start
MS Office set 3 30 Start
MS Office set 4 30 Start
MS Office set 5 30 Start
MS Office set 6 30 Start
MS Office set 7 30 Start
MS Office set 8 30 Start
MS Office set 9 30 Start
MS Office set 10 30 Start
MS Office set 11 30 Start
MS Office set 12 30 Start