Welcome to yet another Microsoft Excel online MCQ quiz. This is the sixth set in the series and we are presenting 400+ multiple choice questions from Microsoft Excel alone.
I’ve put enough effort to compile and present this MCQ quiz so that it is most reliable and error free. However, if anything skipped and you discovered any mistake, please let me know by commenting below or sending email through ‘Contact Us’ page. One thing to note, you’ll need to copy and paste the question that you wish to draw my attention because only set number and question number can’t help me much. The question numbers are generated dynamically from among 400+ MS Excel MCQ questions bank.
Enjoy the 6th MS Excel Online MCQ Quiz
Microsoft Excel MCQ Quiz Set 06
Charryjean Sayas Danzalan says
i like this
MCQ Sets says
Thank you Charyjeans
Surya Prakash Acharya says
Sir, Namaskar…. _/\_
Correct answer shows b) Ctrl Key ……………But Confusion ……………… (Alt Key or Ctrl Key..) ….. sr Plz Clear in Brief.
19. To drag a selected range of data to another worksheet in the same workbook, use the
Tab key
Alt key
Shift key
Ctrl key
MCQ Sets says
Surya,
When we perform drag and drop, we can intend for two operations – copying or moving. Generally Ctrl key helps to copy and Alt key to move. In Excel, because when we drag, the sheet scrolls and can’t reach to sheet tab, but if you hold Alt key and point to sheet tab while dragging, it will switch to the pointed sheet.
So, Alt key is the correct answer without any confusion.
Surya Prakash Acharya says
Thank You !
Sir.
MCQ Sets says
You are most welcome Surya!
Chandra Tamang says
26. In a worksheet you can select
a. The entire worksheet
b. Rows
c. Columns
d. All of the above
(Problem: How does option B is only correct when we can also select column and entire worksheet?)
MCQ Sets says
The correct answer is All of above. I found this question was repeated in bank and one copy marked wrong answer. Updated the question and made correction in qiuz as well. Thank you Chandra to point it out.
Surya Prakash Acharya says
20. Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
Why Formula bar is correct answer plz sr…. clear n brief ….
MCQ Sets says
The correct answer can’t be Formula Bar. I’ve modified the question to adjust.
Thank you for raising this point.
Chiran Dhakal says
Which is the correct answer sir
Chandra Tamang says
In a worksheet you can press Shift + Enter to select entire
• Worksheet
• Row(shows answer)
• Columns
• All of the above
(but when we use Shift+Enter , it moves one cell up , please verify this)
MCQ Sets says
Hahaaa… the question is Shift + Space
Chandra Tamang says
I am feeling uneasy because I am only giving more comment and taking feedback and benefits from dear MCQ sets.
MCQ Sets says
That’s perfectly fine Chandra. I’m glad you are following MCQ Sets very closely and will be proud to be a part of your success!
Mohan Bhatt says
Sir in question no 8 the answer is D but i think the answer become A plz reply
Arjun Raut says
5. Merge cells option can be applied from
a. Format Cells dialog box Alignment Tab
b. Formatting toolbar
c. Both of above
d. None of above
(Are you sure the answer is a. Format Cells dialog box Alignment Tab ?) Can’t we apply merge and center from Formatting Toolbar?
Suresh Khanal says
Merge and Center has two tasks done at once. It merges the selected cells and aligns content center.
When question asks only to merge cells and in option you have Format Cells >> Alignment tab, why to get confused?
Arjun Raut says
Thank you very much, I got the point.
Ajay Rauniyar says
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
Suresh Khanal says
Ajay,
This question is already in mcqsets.com. What you want to ask?