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

Explore more Topics under MS Office

Q221.
Which button do you click to add up a series of numbers?

a.

The autosum button

b.

The Formula button

c.

The quicktotal button

d.

The total button

Discuss
Answer: (a).The autosum button
Q222.
When the formula bar is active, you can see

a.

The edit formula button

b.

The cancel button

c.

The enter button

d.

All of the above

Discuss
Answer: (d).All of the above
Q223.
To copy formatting from one area in a worksheet and apply it to another area you would use:

a.

The Edit > Copy Format and Edit>Paste Format commands form the menu

b.

The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

c.

There is no way to copy and apply formatting in Excel âย€ย“ You have to do it manually

d.

The Format Painter button on the standard toolbar

Discuss
Answer: (d).The Format Painter button on the standard toolbar
Q224.
In a worksheet you can select

a.

The entire worksheet

b.

Rows

c.

Columns

d.

All of the above

Discuss
Answer: (d).All of the above
Q225.
When you link data maintained in an excel workbook to a word document

a.

The word document cannot be edit

b.

The word document contains a reference to the original source application

c.

The word document must contain a hyperlink

d.

The word document contains a copy of the actual data

Discuss
Answer: (b).The word document contains a reference to the original source application
Q226.
Which area in an excel window allows entering values and formulas

a.

Title bar

b.

Menu bar

c.

Formula bar

d.

Standard toolbar

Discuss
Answer: (c).Formula bar
Q227.
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a.

Unfreeze panes command on the window menu

b.

Freeze panes command on the window menu

c.

Hold titles command on the edit menu

d.

Split command on the window menu

Discuss
Answer: (b).Freeze panes command on the window menu
Q228.
To edit in an embedded excel worksheet object in a word document

a.

Use the excel menu bar and toolbars inside the word application

b.

Edit the hyperlink

c.

Edit the data in a excel source application

d.

Use the word menu bar and toolbars

Discuss
Answer: (a).Use the excel menu bar and toolbars inside the word application
Q229.
To create a formula, you can use:

a.

Values but not cell references

b.

Cell references but not values

c.

Values or cell references although not both at the same time

d.

Value and cell references

Discuss
Answer: (d).Value and cell references
Q230.
Status indicators are located on the

a.

Vertical scroll bar

b.

Horizontal scroll bar

c.

Formula bar

d.

Standard toolbar

Discuss
Answer: (c).Formula bar
Page 23 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!

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

PHP

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

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Digital Logic Design

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

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

C# programming

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

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...