Advanced Excel test (Advanced)
40 questions · 40 minutes · Free
Power Query, Power Pivot, dynamic arrays and automation in Excel.
What it covers
- Power Query
- Power Pivot and DAX basics
- Dynamic array functions (FILTER, UNIQUE, LET)
- Macros and VBA basics
- Financial and statistical functions
Interview format
- Questions: 40 questions — 24 multiple choice, 16 multi-answer
- Time: 40 minutes, timed from the first question
- Difficulty: Advanced
- Skill area: Data
- Price: Free
Earn a certificate
The Advanced Excel test is one of the 7 tests of the Data Analyst: Advanced 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 Advanced Excel test?
- 40 questions (24 multiple choice, 16 multi-answer), with 40 minutes to answer them.
- What does the Advanced Excel test cover?
- Power Query, Power Pivot and DAX basics, Dynamic array functions (FILTER, UNIQUE, LET), Macros and VBA basics, Financial and statistical functions.
- Is the Advanced Excel test free?
- Yes. It is free to take with a readyforhires account.
- What level is the Advanced Excel test?
- Advanced, in Data.