Description
INDEX and MATCH, XLOOKUP search modes, dynamic arrays, SUMPRODUCT and date conditions, data validation and cleanup, Power Query, and reports that survive new data.
What this test covers
- Data cleanup and validation6 questions
- Lookup functions4 questions
- Conditional and aggregate functions3 questions
- Formulas and references2 questions
- Text and dates2 questions
- Sorting, filtering, and formatting1 question
Questions
18
Time Limit
36 minutes
Passing score
70%
Languages
English, Русский
Your progress will be saved automatically
You can start without an account. Sign up later to keep your results.
Similar tests
More tests on the same topic — often other difficulty levels.
Formulas and cell references, copying formulas, common errors, sorting and filters, basic counting functions, and picking a chart.
Lookups with VLOOKUP and XLOOKUP, SUMIFS and COUNTIF, text and dates, conditional formatting, Excel tables, and pivot tables.
Before you start
Do I need an account?
No. You can start right away. An account saves results, retries, and progress across devices.
Is there a time limit?
Yes — about 36 minutes for this test.
What score do I need to pass?
You need 70% correct across 18 questions.
Will I see the correct answers?
This test shows your score only; a full answer walkthrough is not enabled.
Which languages is this test available in?
Published versions: English, Русский.