Description
Lookups with VLOOKUP and XLOOKUP, SUMIFS and COUNTIF, text and dates, conditional formatting, Excel tables, and pivot tables.
What this test covers
- Text and dates4 questions
- Pivot tables and charts4 questions
- Lookup functions3 questions
- Conditional and aggregate functions3 questions
- Sorting, filtering, and formatting2 questions
Questions
16
Time Limit
32 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.
INDEX and MATCH, XLOOKUP search modes, dynamic arrays, SUMPRODUCT and date conditions, data validation and cleanup, Power Query, and reports that survive new data.
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 32 minutes for this test.
What score do I need to pass?
You need 70% correct across 16 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, Русский.