Top 35 MS Excel MCQ Questions And Answers (Updated)

Below are top 35 MS Excel MCQ Questions and answers. These Microsoft Excel multiple-choice questions will help students with skill enhancement and exam preparation for MS-CIT, Entrance and University exams. This MCQ quiz includes questions on both, basic as well as advanced MS excel. These objective type choice based question sets can be used to gain knowledge about Google Sheets or other open-source spreadsheet tools.

Part 1: MCQs on Basics of MS Excel (Level: Easy)

MS Excel stands for ___________

A. Micromax Excel

B. Management Excel

C. Microsoft Excel

D. Microsoft Excess

MS Excel is a ________.

A. Database Management software

B. Presentation software

C. Workbook software

D. Spreadsheet software

________is the best alternative to MS Excel offered by Google Inc.

A. Google Slides

B. Google Sheets

C. Google Files

D. Google Keep

Free online version of MS excel is known as ________

A. Office for the web

B. Excel Mobile

C. Word Mobile

D. Excel for the web

Microsoft Excel 2019 has column limit of __________

A. 13684

B. 16384

C. 18634

D. 84163

MS Excel 2019 has row limit of __________

A. 1,048,576

B. 4,81,0576

C. 16384

D. 1,57,648

MS Excel 2019 has maximum column width limit is of __________characters

A. 256

B. 512

C. 255

D. 128

Microsoft Excel was first time launched in ______ by the Microsoft Corporation

A. 1985

B. 1991

C. 1995

D. 1998

Formulas in Excel start with ________

A. /

B. f

C. –

D. =

__________ is a free lightweight version of MS Excel available as part of Office on the web.

A. Excel for the web

B. Excel Mobile

C. Office Mobile

D. MS Access for Web

MS Excel file can NOT be directly exported as ______

A. PDF

B. TXT

C. PPT

D. CSV

A file that contains one or more worksheets to organize data is known as _______

A. Workbook

B. Excelbook

C. Datasheet

D. Spreadsheet

How cells are named in ms excel?

A. using rename option

B. using name box

C. simply double click on sheet name

D. simply double click on cell and name it

Part 2: MCQ on MS Excel Worksheets (Level: Moderate)

This section covers multiple choice questions on MS excel worksheet, cells, rows, columns, and related concepts. These questions are suitable for moderate users.

The intersection of a column and a row in MS Excel worksheet is known as _______

A. Row

B. Cell

C. Column

D. Tab

In Microsoft Excel spreadsheets, rows are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

In Microsoft Excel spreadsheets, COLUMNS are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

In Microsoft Excel spreadsheets, CELLS are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

___________ is a collection of cells organized in rows and columns where you keep and manipulate the data.

A. Workbook

B. Worksheet

C. Spreadsheet

D. ARRAY

Select correct statement

A. Each Excel workbook can contain multiple worksheets.

B. Each Excel worksheet can contain multiple workbooks.

C. Each Excel workbook can contain multiple spreadsheets.

D. Each Excel worksheet can contain multiple spreadsheets.

Part 3: MCQ On MS Excel Functions (Level: Moderate)

Given below are the objective type questions on various functions of Microsoft Excel and Google Spreadsheets. These questions are mainly designed for moderate users.

In Microsoft Excel cells, function must start with ________

A. $

B. =

C. ” “

D. F

Microsoft Excel uses the _________ function to calculate the results in the data table

A. ‘RESULT’

B. ‘CALTAB’

C. ‘TABLE’

D. ‘AUTOSUM’

_________function in MS Excel worksheet represents the total number(s) of entries in the cell(s).

A. SUM

B. AVG

C. COUNT

D. TOTAL

__________is NOT a Function in Microsoft Excel spreadsheets.

A. HYPERLINK

B. COUNTIF

C. MIN

D. AVG

In MS Excel spreadsheet, Data can be sorted using ________.

A. Filter function

B. ARRAY function

C. Lookup function

D. Operator function

The __ feature of ms excel quickly completes a series of data.

A. Auto Filter

B. Auto Complete

C. Auto Fill

D. Auto Sum

Which one is not a function in ms excel?

A. PROPER

B. AVERAGE

C. COUNT

D. CLEAR

In MS Excel_________feature makes it easier to add repetitive data to a worksheet

A. Autosum

B. Sort

C. Filter

D. Autocomplete

In MS Excel, Page border option is available under _______ tab.

A. Insert

B. Page Layout

C. View

D. None of the above

Part 4: MCQ on MS Excel Shortcuts (Level: Moderate to High)

Using shortcuts is really convenient and curious thing for MS excel lovers. You can also make yourself familiar with these shortcuts to become excel pro 😉

In MS Excel, Ctrl+S can be used to_______

A. Save

B. Save As

C. Switch between opened tab

D. Start New Workbook

In MS Excel, keyboard shortcut keys to create a new workbook is _____

A. Tab+N

B. Fn+N

C. Alt+N

D. Ctrl+N

In MS Excel, the keyboard shortcut key to Open the Save As dialog box is ________

A. Ctrl+S

B. F2

C. Ctrl+N

D. F12

In MS Excel, Workbook can be closed using keyboard shortcut ______

A. Ctrl+C

B. Ctrl+W

C. Esc

D. Ctrl+E

_____ can be used as a keyboard shortcut key to check spelling in MS Excel.

A. F1

B. F7

C. F2

D. F12

Which key is used for help in MS excel?

A. Windows + H

B. F1

C. F10

D. F2

Open workbooks can easily be switched using _____

A. Ctrl+S

B. Alt+S

C. Ctrl+Alt

D. Ctrl+Tab

This is all about MS Excel MCQ with Solutions useful for exam preparation and skill development.

You’ll also like Digital Business MCQ With Answers (Updated in 2021)