35 questions · 60 minutes · Excel
Advance Excel Formulas & Functions practice quiz
35 MCQs from IF, Nested IF, VLOOKUP, HLOOKUP, INDEX, MATCH, LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE, TEXTJOIN, TODAY, NOW, DATE, DATEDIF, NETWORKDAYS.
Before you start
Answer all 35 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
- 35
- Time
- 60 minutes
- Marks
- 35
- Subject
- Excel
- Marking
- Server-side
What it asks
The first few questions
- =IF(logical_test, value_if_true, value_if_false) is the syntax of which function?
- Which function is used to look up data vertically in Excel?
- Which function returns the current date in Excel?
- Which function is used to remove extra spaces in text?
31 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.