Excel interview mock test
13 tasks covering what pre-employment Excel tests ask most: lookups, SUMIFS, IF, pivots, formatting. 25 minutes, no hints.
- 13 tasks
- 25 minutes
- No hints or solutions
- Pass mark 70%
Skills covered
Absolute references · SUMIFS · COUNTIFS · IF logic · VLOOKUP · XLOOKUP · INDEX + MATCH · Error handling · Text functions · Dates · Pivot tables · Conditional formatting · Sort and filter
Without Premium, the pivot, chart and formatting tasks come from the free preview of those lessons. Premium unlocks the harder versions.