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

Explore more Topics under MS Office

Q131.
In MS-Excel concatenation of text can be done using

a.

Apostrophe (')

b.

Exclamation (!)

c.

Both (a) and (b)

d.

Ampersand (&)

Discuss
Answer: (d).Ampersand (&)
Q132.
In MS-Excel how many characters can be typed in a single cell?

a.

25600

b.

10240

c.

32,000

d.

65,535

Discuss
Answer: (d).65,535
Q133.
In MS-Excel data can be arranged in a worksheet in a easy to understand manner using

a.

Auto formatting

b.

Applying styles

c.

Changing fonts

d.

All of above

Discuss
Answer: (d).All of above
Q134.
In MS-Excel worksheet can have a maximum of .... Number of rows

a.

25600

b.

10240

c.

32,500

d.

65,535

Discuss
Answer: (d).65,535
Q135.
In MS-Excel the following is not an example of a value

a.

667

b.

July 23,2001

c.

97%

d.

Serial Number 50771

Discuss
Answer: (d).Serial Number 50771
Q136.
In MS-Excel worksheet range is a

a.

A command used for data modeling

b.

A range of values such as from 23 to 234

c.

A group of cells

d.

None of these

Discuss
Answer: (c).A group of cells
Q137.
In MS-Excel on a sheet the active cell is indicated by

a.

A dark wide border

b.

A dotted border

c.

A blinking border

d.

None of above

Discuss
Answer: (a).A dark wide border
Q138.
In MS-Excel you can select a single range of cells by

a.

Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b.

Dragging over the desired cells

c.

Pressing the Shift key and an arrow key

d.

All of the above

Discuss
Answer: (a).Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Q139.
All formula in MS-Excel start with

a.

&percent;

b.

+

c.

=

d.

-

Discuss
Answer: (c).=
Q140.
In MS-Excel you can print

a.

A range of cells by range name

b.

An entire worksheet

c.

A single worksheet

d.

All of the above

Discuss
Answer: (d).All of the above
Page 14 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!

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

Software Engineering

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

Digital Image Processing (DIP)

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

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Digital Logic Design

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

Software Architecture and Design

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

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Wireless and Mobile Communications

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