adplus-dvertising

Welcome to the MS Excel MCQs Page

Dive deep into the fascinating world of MS Excel with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of MS Excel, a crucial aspect of MS Office. In this section, you will encounter a diverse range of MCQs that cover various aspects of MS Excel, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within MS Office.

frame-decoration

Check out the MCQs below to embark on an enriching journey through MS Excel. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of MS Office.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of MS Excel. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

MS Excel MCQs | Page 4 of 47

Explore more Topics under MS Office

Q31.
When a row of data is to be converted into columns

a.

Copy the cells in row, select the same number of cells in row and paste

b.

Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

c.

Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK

d.

Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK

Discuss
Answer: (d).Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Q32.
Ctrl + D shortcut key in Excel will

a.

Open the font dialog box

b.

Apply double underline for the active cell

c.

Fill down in the selection

d.

None of above

Discuss
Answer: (c).Fill down in the selection
Q33.
The short cut key Ctrl + R is used in Excel to

a.

Right align the content of cell

b.

Remove the cell contents of selected cells

c.

Fill the selection with active cells to the right

d.

None of above

Discuss
Answer: (c).Fill the selection with active cells to the right
Q34.
The command Edit >> Fill Across Worksheet is active only when

a.

One sheet is selected

b.

When many sheets are selected

c.

When no sheet is selected

d.

None of above

Discuss
Answer: (b).When many sheets are selected
Q35.
Which of the following series type is not valid for Fill Series dialog box?

a.

Linear

b.

Growth

c.

Autofill

d.

Time

Discuss
Answer: (d).Time
Q36.
Which of the following you can paste selectively using Paste Special command?

a.

Validation

b.

Formats

c.

Formulas

d.

All of above

Discuss
Answer: (d).All of above
Q37.
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

a.

Square

b.

Percentage

c.

Goal Seek

d.

Divide

Discuss
Answer: (d).Divide
Q38.
Edit >> Delete command

a.

Deletes the content of a cell

b.

Deletes Formats of cell

c.

Deletes the comment of cell

d.

Deletes selected cells

Discuss
Answer: (d).Deletes selected cells
Q39.
To remove the content of selected cells you must issue ______ command

a.

Edit >> Delete

b.

Edit >> Clear >> Contents

c.

Edit >> Clear >> All

d.

Data >> Delete

Discuss
Answer: (b).Edit >> Clear >> Contents
Q40.
The Delete key of keyboard is assigned to which command in Excel?

a.

Edit >> Clear >> Contents

b.

Edit >> Delete

c.

Edit >> Clear >> All

d.

All of above

Discuss
Answer: (a).Edit >> Clear >> Contents
Page 4 of 47

Suggested Topics

Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...