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.

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

01

MS Word

02

MS Powerpoint

03

MS Access

04

Shortcut Keys

Q131.

In MS-Excel concatenation of text can be done using

Apostrophe (')

Exclamation (!)

Both (a) and (b)

Ampersand (&)

Discuss

Answer: (d).Ampersand (&)

Q132.

In MS-Excel how many characters can be typed in a single cell?

25600

10240

32,000

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

Auto formatting

Applying styles

Changing fonts

All of above

Discuss

Answer: (d).All of above

Q134.

In MS-Excel worksheet can have a maximum of .... Number of rows

25600

10240

32,500

65,535

Discuss

Answer: (d).65,535

Q135.

In MS-Excel the following is not an example of a value

667

July 23,2001

97%

Serial Number 50771

Discuss

Answer: (d).Serial Number 50771

Q136.

In MS-Excel worksheet range is a

A command used for data modeling

A range of values such as from 23 to 234

A group of cells

None of these

Discuss

Answer: (c).A group of cells

Q137.

In MS-Excel on a sheet the active cell is indicated by

A dark wide border

A dotted border

A blinking border

None of above

Discuss

Answer: (a).A dark wide border

Q138.

In MS-Excel you can select a single range of cells by

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

Dragging over the desired cells

Pressing the Shift key and an arrow key

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

&percent;

Discuss

Answer: (c).=

Q140.

In MS-Excel you can print

A range of cells by range name

An entire worksheet

A single worksheet

All of the above

Discuss

Answer: (d).All of the above

Page 14 of 47

Welcome to the MS Excel MCQs Page

MS Excel MCQs | Page 14 of 47

Explore more Topics under MS Office

MS Word

MS Powerpoint

MS Access

Shortcut Keys

Suggested Topics

Java Spring Framework

Systems Programming

PHP

Artificial Intelligence

Computer Architecture

Compiler Design

Java Programming

Object Oriented Programming Using C++

Computer Graphics