20 questions · 30 minutes · Excel
Advance Excel Practice 1 practice quiz
20 MCQs on IF, Nested IF, VLOOKUP, HLOOKUP, INDEX, and MATCH functions in Excel.
Before you start
Answer all 20 questions. 1 mark each. No negative marking.
You can take this without an account and you will still get the full marked review. Only signed-in attempts are saved — sign in first if you want this one kept in your history.
- Questions
- 20
- Time
- 30 minutes
- Marks
- 20
- Subject
- Excel
- Marking
- Server-side
What it asks
The first few questions
- What is the correct syntax of the IF function in Excel?
- Which function can check multiple conditions one after another?
- Which lookup function searches for a value vertically in the first column?
- In VLOOKUP, which argument decides whether an exact or approximate match is found?
16 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.