MS Excel MCQ Questions And Answers (Updated)
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