Skip to content
Home » MS Excel MCQ Questions And Answers (Updated 2021) » Page 2

MS Excel MCQ Questions And Answers (Updated 2021)

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

View Answer

B. =

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

A. ‘RESULT’

B. ‘CALTAB’

C. ‘TABLE’

D. ‘AUTOSUM’

View Answer

C. ‘TABLE’

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

A. SUM

B. AVG

C. COUNT

D. TOTAL

View Answer

C. COUNT

__________is NOT a Function in Microsoft Excel spreadsheets.

A. HYPERLINK

B. COUNTIF

C. MIN

D. AVG

View Answer

D. AVG

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

A. Filter function

B. ARRAY function

C. Lookup function

D. Operator function

View Answer

A. Filter

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

A. Auto Filter

B. Auto Complete

C. Auto Fill

D. Auto Sum

View Answer

C. Auto Fill

Which one is not a function in ms excel?

A. PROPER

B. AVERAGE

C. COUNT

D. CLEAR

View Answer

D. CLEAR

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

A. Autosum

B. Sort

C. Filter

D. Autocomplete

View Answer

D. Autocomplete

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

A. Insert

B. Page Layout

C. View

D. None of the above

View Answer

D. None of the above

Pages: 1 2 3
error: