Intermediate Excel test (Intermediate)
30 questions · 35 minutes · Free
Lookups, PivotTables, text and date functions in Excel.
Take the Intermediate Excel test
What it covers
- VLOOKUP, XLOOKUP and INDEX/MATCH
- PivotTables and PivotCharts
- Text and date functions
- Data validation
- What-if analysis
Interview format
- Questions: 30 questions — 18 multiple choice, 12 multi-answer
- Time: 35 minutes, timed from the first question
- Difficulty: Intermediate
- Skill area: Data
- Price: Free
Earn a certificate
The Intermediate Excel test is one of the 7 tests of the Data Analyst: Intermediate learning path. Pass it and the other 6 tests at 70% or more and readyforhires issues you a verifiable certificate in your name, with its own code and verify link to share or add to LinkedIn.
Frequently asked questions
- How many questions are in the Intermediate Excel test?
- 30 questions (18 multiple choice, 12 multi-answer), with 35 minutes to answer them.
- What does the Intermediate Excel test cover?
- VLOOKUP, XLOOKUP and INDEX/MATCH, PivotTables and PivotCharts, Text and date functions, Data validation, What-if analysis.
- Is the Intermediate Excel test free?
- Yes. It is free to take with a readyforhires account.
- What level is the Intermediate Excel test?
- Intermediate, in Data.