Test: Advanced
Test🔒 Advanced
Test, 30 questions, 45-minute timer, different questions every time
30 questions on everything in Advanced: multiple conditions, XLOOKUP, IFS and IFERROR, text, dates and summaries.
What's tested
- Multiple conditions
- Lookups and logic
- Text, dates and summaries
The parts
- Multiple conditions: 6 questions
- Lookups: 5 questions
- Logic: 5 questions
- Text: 5 questions
- Dates and numbers: 5 questions
- Summaries: 4 questions
How it works
The timer starts as soon as you begin. If you finish early, the test stops straight away. You don't get tips, and you pass from 70%. Afterwards you see your score for each part.