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 : 57
When a row of data is to be converted into columns

Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
View Answer   Discuss

Question No : 58
Ctrl + D shortcut key in Excel will

Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
View Answer   Discuss

Question No : 59
The short cut key Ctrl + R is used in Excel to

Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above
View Answer   Discuss

Question No : 60
Which menu option can be used to split windows into two?

Format -> Window
View -> Window-> Split
Window -> Split
View > Split
View Answer   Discuss

Question No : 61
Getting data from a cell located in a different sheet is called ......

Accessing
Referencing
Updating
Functioning
View Answer   Discuss

Question No : 62
Which of the following is not a valid data type in Excel?

Number
Character
Label
Date/Time
View Answer   Discuss

Question No : 63
Which elements of a worksheet can be protected from accidental modification?

Contents
Objects
Scenarios
All of the 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