Log in to Jobaaj

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Microsoft excel MCQ With Answers

40 practice questions · Last updated on Aug 25, 2026

Q&A guide Share:

Excel interviews try to establish whether you use the tool as a grid or as a system. Expect questions on VLOOKUP versus INDEX-MATCH versus XLOOKUP, absolute and mixed references, PivotTable requirements, Power Query for repeatable transformation, dynamic array functions such as FILTER, LET and LAMBDA, and how you structure a model others will rely on. Knowing why a workbook is slow, and when a task has outgrown Excel, are strong differentiators. The questions below cover both.

Microsoft excel MCQ

1.What is the main limitation of VLOOKUP compared with INDEX-MATCH?

2.What is the default match type of XLOOKUP?

3.What does the fourth argument of VLOOKUP set to FALSE specify?

6.What is required of source data for a PivotTable to work correctly?

7.Do PivotTables update automatically when the source data changes?

8.What is the main advantage of formatting a range as an Excel Table with Ctrl+T?

9.Which function sums values meeting multiple criteria?

10.Which dynamic array function returns all rows matching a condition?

11.What does the LET function do?

12.What does LAMBDA allow you to create?

13.Which function removes leading and trailing spaces from text?

14.What is the most common symptom of numbers stored as text?

15.What is Power Query primarily used for?

16.Which Power Query operation converts cross-tabulated columns into flat rows?

17.Which Power Query operation is equivalent to a SQL join?

18.Which formula-based conditional formatting rule highlights an entire row when column E says Overdue?

19.Why should conditional formatting be used sparingly?

20.Which functions are volatile and recalculate on every workbook change?

21.Why should whole-column references such as SUMIF(A:A, ...) be avoided in large workbooks?

22.What does pressing Ctrl+End do, and why does it matter for file size?

24.What does the IFERROR function do?

25.Which function counts cells meeting multiple conditions?

26.What does the UNIQUE function return?

27.Which feature restricts what can be entered into a cell?

29.Why should a rate or assumption never be typed directly inside multiple formulas?

30.What does a named range give you?

31.Which tool shows which cells a formula depends on?

32.What is the correct tool for automating repeated data import and cleaning?

33.Which file extension is required for a workbook containing macros?

34.Why should Select and Activate be avoided in VBA?

35.What does the Data Model in Excel allow?

36.Approximately how many rows can a single Excel worksheet hold?

37.Which chart type is most appropriate for showing change over time?

38.Why should a bar chart's value axis start at zero?

39.What is the fastest way to check whether an analysis is correct?

All trademarks are the property of their respective owners

All rights reserved @ 2026 Nishtya Infotech (India) Ltd.

Log in to Jobaaj

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as

Jobseeker
Employer