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

Explore more Topics under MS Office

Q121.
In MS-Excel you can use the drag and drop method to

a.

Copy cell contents

b.

Move cell contents

c.

Add cell contents

d.

(A) and (B)

Discuss
Answer: (d).(A) and (B)
Q122.
In MS-Excel which of the following is not a worksheet design criterion?

a.

Efficiency

b.

Aditibility

c.

Description

d.

All of these

Discuss
Answer: (c).Description
Q123.
In MS-Excel it is acceptable to let long text flow into adjacent cells on a worksheet when

a.

Data will be entered in the adjacent cells

b.

No data will be entered in the adjacent cells

c.

Both (a) and (b)

d.

None of these

Discuss
Answer: (b).No data will be entered in the adjacent cells
Q124.
In MS-Excel a fast way to add up data in a column is to click in the cell below the numbers and then

a.

Click subtotals on the data menu

b.

View the sum in the formula bar

c.

Click the autosum button on the standard toolbar, then press enter

d.

All of above

Discuss
Answer: (c).Click the autosum button on the standard toolbar, then press enter
Q125.
Right clicking something in MS-Excel

a.

Deletes the object

b.

Nothing the right mouse button is there for left handed people

c.

Opens a shortcut menu listing everything you can do to the object

d.

None of these

Discuss
Answer: (c).Opens a shortcut menu listing everything you can do to the object
Q126.
In MS-Excel what symbol is used before a number to make it a label?

a.

" (quote)

b.

= (equal)

c.

_ (underscore)

d.

None of these

Discuss
Answer: (a)." (quote)
Q127.
In MS-Excel which symbol must all formula begin with?

a.

=

b.

+

c.

(

d.

None of these

Discuss
Answer: (a).=
Q128.
In MS-Excel which of the following formulas is not entered correctly?

a.

=10+75

b.

=B6*B2

c.

=B6+23

d.

17+59

Discuss
Answer: (d).17+59
Q129.
In MS-Excel which of the following formulas will not be calculated?

a.

=SUM(Sales)-A2

b.

=SUM(A1:A4)*0.5

c.

+SUM(A1:A5)/(10-10)

d.

Both (a) and (c)

Discuss
Answer: (c).+SUM(A1:A5)/(10-10)
Q130.
In MS-Excel typical worksheet has .... Number of columns

a.

128

b.

256

c.

512

d.

None of these

Discuss
Answer: (b).256
Page 13 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!

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Object Oriented Programming

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

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...