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

Explore more Topics under MS Office

Q341.
In Excel, by default Numeric Values appears in

a.

Left aligned

b.

Right aligned

c.

Center aligned

d.

Justify aligned

Discuss
Answer: (b).Right aligned
Q342.
To show/hide the grid lines in Microsoft Excel 2007

a.

Page Layout -> Grid lines -> View

b.

Insert -> Grid lines -> View

c.

View -> Grid lines -> View

d.

Edit -> Grid lines -> View

Discuss
Answer: (a).Page Layout -> Grid lines -> View
Q343.
What will be the result if you type =A1=B1 in cell C1?

a.

Yes or No

b.

True or False

c.

Value of A1

d.

Value of B1

Discuss
Answer: (b).True or False
Q344.
In Excel _______ may not contain in Formula

a.

Text Constant

b.

Number Constant

c.

Circular Reference

d.

All of them

Discuss
Answer: (c).Circular Reference
Q345.
A function inside another function is called _______

a.

Nested function

b.

Round function

c.

Sum function

d.

Text function

Discuss
Answer: (a).Nested function
Q346.
Which of the following is not an underline option in the format cells dialog box?

a.

Double

b.

Single Accounting

c.

Double Accounting

d.

Single Engineering

Discuss
Answer: (d).Single Engineering
Q347.
Formulas in Excel start with

a.

%

b.

=

c.

+

d.

–

Discuss
Answer: (b).=
Q348.
The default header for a worksheet is

a.

Username

b.

Date and Time

c.

Sheet tab Name

d.

None

Discuss
Answer: (d).None
Q349.
Which of the following is not an option of the spelling dialog box?

a.

Ignore

b.

Ignore all

c.

Edit

d.

Change

Discuss
Answer: (c).Edit
Q350.
Which of the following methods will not enter data in a cell?

a.

Pressing the Esc key

b.

Pressing an arrow key

c.

Pressing the tab key

d.

Clicking the enter button to the formula bar

Discuss
Answer: (a).Pressing the Esc key
Page 35 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!

Java Programming

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

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Formal Languages and Automata Theory

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

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

Software Engineering

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

Management Information Systems

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

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Computer Architecture

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