Description
Formulas and cell references, copying formulas, common errors, sorting and filters, basic counting functions, and picking a chart.
What this test covers
- Formulas and references5 questions
- Sorting, filtering, and formatting3 questions
- Conditional and aggregate functions2 questions
- Text and dates1 question
- Pivot tables and charts1 question
Questions
12
Time Limit
24 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.
Lookups with VLOOKUP and XLOOKUP, SUMIFS and COUNTIF, text and dates, conditional formatting, Excel tables, and pivot tables.
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 24 minutes for this test.
What score do I need to pass?
You need 70% correct across 12 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, Русский.