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

Explore more Topics under MS Office

01

MS Word

02

MS Powerpoint

03

MS Access

04

Shortcut Keys

Q251.

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

None of these

Select Format > Money from the menu

Click the Currency Style button on the formatting toolbar

You have to retype everything and manually add the dollar signs, commas, and decimals

Discuss

Answer: (c).Click the Currency Style button on the formatting toolbar

Q252.

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

Option buttons

List boxes

Text boxes

Combo boxes

Discuss

Answer: (c).Text boxes

Q253.

Which of the following options is not located in the Page Setup dialog box?

Page Break Preview

Page Orientation

Margins

Headers and Footers

Discuss

Answer: (a).Page Break Preview

Q254.

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Pie chart

Row chart

Line chart

Column chart

Discuss

Answer: (c).Line chart

Q255.

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Press Ctrl +Home

Press Home

Press Shift + Home

Press Alt + Home

Discuss

Answer: (a).Press Ctrl +Home

Q256.

Which of the following methods can not be used to edit the contents of a cell?

Press the Alt key

Clicking the formula bar

Pressing the F2 key

Double clicking the cell

Discuss

Answer: (a).Press the Alt key

Q257.

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:

Press the Erase key

Press Esc

Press the Enter button

Press the Edit Formula button

Discuss

Answer: (b).Press Esc

Q258.

To view a cell comment

click the edit comment command on the insert menu

click the display comment command on the window menu

position the mouse pointer over the cell

click the comment command on the view menu

Discuss

Answer: (c).position the mouse pointer over the cell

Q259.

When you want to insert a blank imbedded excel object in a word document you can

Click the object command on the insert menu

Click the office links button on the standard toolbar

Click the create worksheet button on the formatting toolbar

Click the import excel command on the file menu

Discuss

Answer: (a).Click the object command on the insert menu

Q260.

To save a workbook, you:

Click the save button on the standard toolbar from the menu

Press Ctrl+F5

Click Save on the Windows Start button

Select Edit>Save

Discuss

Answer: (a).Click the save button on the standard toolbar from the menu

Page 26 of 47

Welcome to the MS Excel MCQs Page

MS Excel MCQs | Page 26 of 47

Explore more Topics under MS Office

MS Word

MS Powerpoint

MS Access

Shortcut Keys

Suggested Topics

Cyber Security

IT Fundamentals

Java Programming

HTML

Object Oriented Programming

Computer Graphics

Hadoop

C# programming

R Programming