Microsoft Excel (MS Excel) Multiple Choice Questions (MCQs)
We have compiled a list of 100+ questions with answers from Microsoft Excel (MS Excel) that help you to check your basic knowledge of MS Excel and prepare for competitive exams. These Microsoft excel multiple choice questions with answers are prepared by the subject experts from authentic resources. Attempt all the questions and check your MS Excel knowledge online.
This category includes the topics such as concept of electronic spreadsheets, types, organization of spreadsheet applications, cells, rows, columns, worksheets, workbooks and workspaces, creating opening and saving workbooks, screen elements, editing copying moving and delete cell contents, cell formatting, using formulas, relative absolute and mixed cell references, basic functions, generating series, default options, sorting filtering data, summarizing and sub totals, charts, header footer, speller, customizing menu and toolbar, import export data, pivot table, goal seek, scenario and audit, page setting, preview and printing.
Following are the important multiple choice questions with answers from the Microsoft Excel (MS Excel) section. You can choose the correct answer from option A, B, C and D.
MS Excel MCQs Practice MCQ Question and Answer
1
Which Excel function is used to combine text from multiple cells with a delimiter?
Answer & Solution
Answer: Option B
TEXTJOIN combines text with a specified delimiter and can ignore empty cells.
2
What does the SORTBY function do?
Answer & Solution
Answer: Option B
SORTBY sorts one range based on the values in another range.
3
Which function returns a dynamic array of random numbers between 0 and 1?
Answer & Solution
Answer: Option A
RANDARRAY is new in Excel 365 and returns dynamic random numbers.
4
Which function helps link to another workbook in Excel?
Answer & Solution
Answer: Option A
HYPERLINK can link to external workbooks or URLs.
5
Which tab in Excel contains the 'Get & Transform Data' tools?
Answer & Solution
Answer: Option C
'Get & Transform' tools are under the Data tab for Power Query use.
6
Which new Excel chart is ideal for showing hierarchical data?
Answer & Solution
Answer: Option B
Treemap charts display hierarchical data in nested rectangles.
7
What is the use of the LET function in Excel?
Answer & Solution
Answer: Option A
LET allows naming of expressions inside a formula for better performance and clarity.
8
What feature in Excel 365 auto-fills formulas using AI?
Answer & Solution
Answer: Option A
Flash Fill uses pattern recognition to auto-complete data.
9
Which Excel function extracts a value based on multiple conditions?
Answer & Solution
Answer: Option A
IFS allows evaluating multiple conditions in one formula.
10
Which Excel 365 feature allows filtering a range with multiple conditions?
Answer & Solution
Answer: Option C
FILTER function lets you extract data based on dynamic conditions.
11
What does the SEQUENCE() function return?
Answer & Solution
Answer: Option C
SEQUENCE generates an array of sequential numbers.
12
Which function can generate a list of distinct values?
Answer & Solution
Answer: Option A
UNIQUE returns a list without duplicates.
13
Which feature in Excel helps audit formulas using arrows?
Answer & Solution
Answer: Option A
Trace Precedents shows dependencies of a formula cell.
14
What is the use of XLOOKUP in Excel 365?
Answer & Solution
Answer: Option A
XLOOKUP is a powerful lookup function replacing older VLOOKUP and HLOOKUP.
15
Which shortcut creates a new worksheet in Excel?
Answer & Solution
Answer: Option B
Shift + F11 quickly inserts a new worksheet.
16
Which function is used to look up a value horizontally in Excel?
Answer & Solution
Answer: Option B
HLOOKUP searches for data in a row (horizontal lookup).
17
Which new Excel function replaces the need for VLOOKUP in many cases?
Answer & Solution
Answer: Option C
XLOOKUP is a modern replacement for VLOOKUP, offering more flexibility.
18
What does the UNIQUE() function do in Excel?
Answer & Solution
Answer: Option B
UNIQUE() returns a list of unique values from a given range.
19
Which function filters data based on criteria?
Answer & Solution
Answer: Option A
FILTER function extracts data based on criteria in real-time.
20
Which function helps to spill array results across cells?
Answer & Solution
Answer: Option D
All these functions can return arrays and cause spilling in dynamic array enabled Excel versions.
21
Which of the following is not a valid Zoom percentage in Excel?