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!

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

Digital Logic Design

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

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

C# programming

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

Data Structures and Algorithms

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

Object Oriented Programming

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

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...