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

Explore more Topics under MS Office

01

MS Word

02

MS Powerpoint

03

MS Access

04

Shortcut Keys

Q11.

Which tool you will use to join some cells and place the content at the middle of joined cell?

From Format Cells dialog box click on Merge Cells check box

From Format Cells dialog box select the Centered alignment

From Format Cells dialog box choose Merge and Center check box

Click on Merge and Center tool on formatting toolbar

Discuss

Answer: (d).Click on Merge and Center tool on formatting toolbar

Q12.

The Name box on to the left of formula bar

shows the name of workbook currently working on

shows the name of worksheet currently working on

shows the name of cell or range currently working on

None of above

Discuss

Answer: (c).shows the name of cell or range currently working on

Q13.

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

work sheet

chart sheet

module sheet

data sheet

Discuss

Answer: (d).data sheet

Q14.

Which of the following is not the correct method of editing the cell content?

Press the Alt key

Press the F2 key

Click the formula bar

Double click the cell

Discuss

Answer: (a).Press the Alt key

Q15.

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

server

source

client

none

Discuss

Answer: (c).client

Q16.

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

F10

F11

Discuss

Answer: (b).F9

Q17.

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

Custom List

Auto Fill Options

Fill Across Worksheet

Fill Series

Discuss

Answer: (a).Custom List

Q18.

Where can you change automatic or manual calculation mode in Excel?

Double CAL indicator on status bar

Go to Tools >> Options >> Calculation and mark the corresponding radio button

Both of above

None of above

Discuss

Answer: (b).Go to Tools >> Options >> Calculation and mark the corresponding radio button

Q19.

How can you show or hide the gridlines in Excel Worksheet?

Go to Tools >> Options >> View tab and mark or remove the check box named Gridline

Click Gridline tool on Forms toolbar

Both of above

None of above

Discuss

Answer: (c).Both of above

Q20.

Which of the following Excel screen components can NOT be turned on or off?

Formula Bar

Status Bar

Tool Bar

None of above

Discuss

Answer: (d).None of above

Page 2 of 47

Welcome to the MS Excel MCQs Page

MS Excel MCQs | Page 2 of 47

Explore more Topics under MS Office

MS Word

MS Powerpoint

MS Access

Shortcut Keys

Suggested Topics

Neural Networks

MongoDB

SQL Server

Internet of Things (IoT)

Compiler Design

Data Science

Artificial Intelligence

Software Architecture and Design

Java Programming