Spreadsheet Practice

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

SkillFunctionsPractice
Totals and averagesSUM, AVERAGELesson 2 Free
Simple rulesIFLesson 5 Free
Counting entriesCOUNTIFLesson 7 Free
Combining names& and TEXTJOINLesson 19 Pro
Fixing messy textTRIM, PROPERLesson 20 Pro
DatesYEAR, TEXTLesson 23 Pro

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

In 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.

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 .