Excel test for administrative assistants: what to expect
Office and admin roles often screen for everyday Excel: totals and averages, simple IF rules, counting entries, cleaning names and emails, and working with dates.
What employers usually test
Take the administrative assistant timed test
Five tasks in a live grid, easiest first. Graded instantly, with a lesson for every gap.
- 5 tasks in a live grid, easiest first. Graded the moment you submit
- About 10 minutes. Skip anything you don't know
- Your level and the exact lessons for your gaps, right away. No signup
- Aced it? Keep going with a bonus round of harder, interview-style tasks
Try a sample task
From lesson 19, Joining text. Graded instantly.
Full name
D2, join first and last name with a space. Fill down to D6.Your 14-day prep plan
About 30 minutes a day. Free lessons first; Pro lessons are marked.
| Day | Focus | Access | Time |
|---|---|---|---|
| 1 | Your first formula | Free | 21 min |
| 2 | SUM, AVERAGE, MIN, MAX & COUNT | Free | 22 min |
| 3 | Relative vs absolute references | Free | 24 min |
| 4 | Percentages & growth | Free | 22 min |
| 5 | The IF function | Free | 22 min |
| 6 | AND, OR & IFS | Free | 24 min |
| 7 | COUNTIF & SUMIF | Free | 23 min |
| 8 | VLOOKUP | Pro | 24 min |
| 9 | Joining text | Pro | 22 min |
| 10 | Cleaning messy data | Pro | 23 min |
| 11 | DATE, YEAR, MONTH & TEXT | Pro | 23 min |
| 12 | UNIQUE & SORT | Pro | 24 min |
| 13 | Timed run: the analyst interview capstone | Pro | 20 min |
| 14 | Retake the skills test and compare | Free | 10 min |
Questions
Do I need advanced formulas?
Usually not. Speed and accuracy on the basics matter more: totals, simple IF rules, sorting and clean text.
What if the test uses an older Excel version?
Everything in the first two tracks works in any version. Newer functions like XLOOKUP are marked in each lesson.
How long should I prepare?
The free lessons take about an hour each with practice, and two weeks covers the plan below.
Prep for other roles
Updated Checked by running: every exercise answer on this page was graded by our formula engine on .