How to use the Excel MCQ Quiz
- 1. Choose the length10 random Excel questions, or all 25. Untick shuffle for a fixed order.
- 2. AnswerPick an option and see straight away whether it's right, with a one-line reason.
- 3. See your scoreFinish to get your score and a review of every question with the correct answer.
What the quiz covers
Excel tests are common in hiring for analyst, MIS, accounts and operations roles, and this quiz covers the functions and features those tests use. The 25 questions are grouped into 12 areas, shown above each question: Functions, References, Lookup, Errors, Shortcuts, Data, Analysis, Text, Dates, View, Dynamic arrays, Charts.
A sample question explained
"What does VLOOKUP's last argument FALSE mean?" The answer is Exact match. TRUE needs a sorted first column. With an unsorted first column, approximate match can quietly return a wrong row, which is why exact match is the safe default.
More questions you'll meet
A few of the other Excel questions in the bank:
- Which function counts cells that meet one condition?
- Which function can look up to the left of the search column?
- What does #DIV/0! mean?
- Which tool summarises data by dragging fields into rows, columns and values?
- Which function removes extra spaces from text?
- What does =DATEDIF(A1, B1, "y") calculate?
- What does Freeze Panes do?
Study tips
- Try every formula question in a real sheet with sample data.
- Learn what each error value means; error questions are quick marks in tests.
- Aim for at least 20 out of 25 on two separate attempts before you treat Excel as revised; one lucky score can hide gaps.
Questions and options are shuffled on each attempt, so a retake is a fresh test. The Excel questions were written by Uncodemy for practice; they aren't copied from any exam or company test.
Frequently asked questions
Which Excel version?
Microsoft 365. A few features like UNIQUE and #SPILL! need Excel 2021 or 365.
Is VBA included?
No. The quiz covers formulas and built-in features.
Is the Excel MCQ quiz free?
Yes. Every question in the Excel MCQ quiz can be answered without signing up. When you finish your first round, we ask once for your name and WhatsApp number to show your score; after that the Excel MCQ quiz and every other Uncodemy tool open straight away.