Test prep by role
Study only what your job's test asks
Employers test different skills for different roles. An admin assistant test rarely asks for INDEX and MATCH. A financial analyst test almost always does. Pick your role and skip the rest.
Each track pulls 10 or 11 of the 28 exercises. Skill lists describe what these jobs usually test, not any one employer's exact test.
Beginner
Administrative assistant
- SUM, AVERAGE and percentages
- Rounding and text in capitals
- COUNTIF by region
- VLOOKUP a manager
- Year from a hire date
10 exercises5-question timed test
Start this track
Beginner
Data entry clerk
- TRIM and PROPER to clean names
- LEFT and & to build codes
- COUNTIF on text
- IFERROR for blanks
- Pulling the year from a date
10 exercises5-question timed test
Start this track
Intermediate
Bookkeeper
- SUMIF and SUMIFS
- COUNTIF thresholds
- Absolute references with $
- VLOOKUP a rate, then calculate
- IFERROR on division
11 exercises5-question timed test
Start this track
Intermediate
Office manager
- Budget totals and averages
- IF with a target
- SUMIF and AVERAGEIF by region
- VLOOKUP and XLOOKUP
- Counting hires before a date
11 exercises5-question timed test
Start this track
Intermediate
HR coordinator
- COUNTIF and COUNTIFS for headcount
- Name cleanup with TRIM and PROPER
- Years of service with DATEDIF
- Hires before a cutoff date
- Employee codes
11 exercises5-question timed test
Start this track
Advanced
Financial analyst
- SUMIFS and COUNTIFS
- Share of total with $ references
- INDEX and MATCH
- XLOOKUP
- Lookup inside a calculation
11 exercises5-question timed test
Start this track