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 33 of 47

Explore more Topics under MS Office

Q321.
Selecting the Column G & H then choose Insert->Columns. What will happen?

a.

2 Columns will be inserted after Column F

b.

2 Columns will be inserted after Column G

c.

2 Columns will be inserted after Column H

d.

2 Columns will be inserted after Column I

Discuss
Answer: (a).2 Columns will be inserted after Column F
Q322.
How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

a.

The Settings tab under the menu Format -> Cells

b.

The Settings tab under the menu Data -> Validation

c.

The Settings tab under the menu Data -> Filter -> Advanced Filter

d.

the Settings tab under the menu Format -> Conditional Formatting

Discuss
Answer: (b).The Settings tab under the menu Data -> Validation
Q323.
Clear the contents by pressing “DELETE” key from a keyboard will clear

a.

Text Only

b.

Format Only

c.

Contents Only

d.

Both Contents and Format

Discuss
Answer: (c).Contents Only
Q324.
Which of the following shortcuts can be used to insert a new line in the same cell?

a.

Enter

b.

Alt + Enter

c.

Ctrl + Enter

d.

Shift + Enter

Discuss
Answer: (b).Alt + Enter
Q325.
What is the quickest way to select entire worksheet?

a.

Choose Edit -> Select all from the Menu

b.

Click on the first column, press Ctrl, and then click on the last column

c.

Click on the first column, press Shift, and then click on the last column

d.

Click on the rectangle box on the upper left corner where column headings and row headings meet

Discuss
Answer: (d).Click on the rectangle box on the upper left corner where column headings and row headings meet
Q326.
A smart tag will be removed from a cell when

a.

the cell is moved

b.

the cell is hidden

c.

the data in the cell is changed or deleted

d.

the formatting of the cell is changed

Discuss
Answer: (c).the data in the cell is changed or deleted
Q327.
Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

a.

Enclose the number is brackets

b.

Place the character T before the number

c.

Place the character TX before the number

d.

Apply the Text format in the cell and type the numbers

Discuss
Answer: (d).Apply the Text format in the cell and type the numbers
Q328.
Selecting the Rows 5 & 6 then choose Insert->Row. What will happen?

a.

2 Rows will be inserted after Row 4

b.

2 Rows will be inserted after Row 5

c.

2 Rows will be inserted after Row 6

d.

2 Rows will be inserted after Row 7

Discuss
Answer: (a).2 Rows will be inserted after Row 4
Q329.
If 4/6 entered in a cell without applying any formats, Excel will treat this as

a.

Fraction

b.

Number

c.

Text

d.

Date

Discuss
Answer: (d).Date
Q330.
How to fit long texts in a single cell with multiple lines?

a.

Start typing in the cell and press the Enter key to start another line

b.

Use the Wrap Text option in the Format -> Alignment menu

c.

Use the Shrink to Fit option in the Format -> Cells -> Alignment menu

d.

All of above

Discuss
Answer: (b).Use the Wrap Text option in the Format -> Alignment menu
Page 33 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!

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Software Engineering

Learn about the systematic approach to developing software with our Software...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...