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!

Formal Languages and Automata Theory

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

Compiler Design

Unravel the process of translating source code into executable programs with our...

Python

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

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...

UNIX

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

Object Oriented Programming

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

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Software Architecture and Design

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