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

Explore more Topics under MS Office

01

MS Word

02

MS Powerpoint

03

MS Access

04

Shortcut Keys

Q161.

In MS-Excel To select several cells or ranges that are not touching each other, you would . . . while selecting

hold down the Ctrl key

hold down the Shift key

hold down the Alt key

None of these

Discuss

Answer: (a).hold down the Ctrl key

Q162.

In MS-Excel the following displays the contents of the active cell

Active cell

Formula bar

Menu bar

None of these

Discuss

Answer: (b).Formula bar

Q163.

In MS-Excel, a certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button ____________.

nothing will print because some cells with data have been omitted

only the cells with gray background will print

the whole sheet will print

only the cells with white background will print

Discuss

Answer: (d).only the cells with white background will print

Q164.

In MS-Excel to open an existing workbook, you can click the Open button on the ...... toolbar.

Drawing

Formatting

Data

Standard

Discuss

Answer: (d).Standard

Q165.

In MS-Excel you can activate a cell by

Pressing the Tab key

Clicking the cell

Pressing an arrow key

All of above

Discuss

Answer: (d).All of above

Q166.

In MS-Excel the following setup options cannot be set in the page setup dialog box?

Printer selection

Vertical or horizontal placement

Orientation

Both (a) and (c)

Discuss

Answer: (a).Printer selection

Q167.

In MS-Excel the following describes how to select all the cells in a single column?

Right click on column and select Pick from list

Use data - text to columns menu item

Left click on the gray column title button

Both (a) and (c)

Discuss

Answer: (c).Left click on the gray column title button

Q168.

MS-Excel and paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

Rows and columns

Headings

Speed

Both (a) and (b)

Discuss

Answer: (c).Speed

Q169.

In MS-Excel which of these will not select all the cells in a document?

Clicking three times with the right mouse button in the spreadsheet

Using the Edit - Select All menu

Pressing Ctrl + A on the keyboard

All of these

Discuss

Answer: (a).Clicking three times with the right mouse button in the spreadsheet

Q170.

In MS-Excel all worksheet formula

Manipulate values

Manipulate labels

Return a formula result

Both (a) and (b)

Discuss

Answer: (c).Return a formula result

Page 17 of 47

Welcome to the MS Excel MCQs Page

MS Excel MCQs | Page 17 of 47

Explore more Topics under MS Office

MS Word

MS Powerpoint

MS Access

Shortcut Keys

Suggested Topics

Digital Image Processing (DIP)

Visual Basic

Java Programming

Microprocessor

IT Fundamentals

Wireless and Mobile Communications

Web Technologies

CompTIA PenTest+ Certification Exam PT0 002

Human Computer Interaction