An organised assistant keeps the whole office running. TestTrick's administrative assistant skills test checks the everyday work, from email and scheduling to Word, Excel and file management, so you can shortlist the most capable applicants in minutes.











About This Test
Admin roles attract a lot of applicants, and CVs rarely show who is genuinely organised. The TestTrick administrative assistant test shows how each candidate handles the tasks they would do every day.
Questions cover email, calendars, data entry, documents and keeping files in order.
Choose Microsoft Excel or Google Sheets to match the software your team uses.
Every applicant takes the same test, so you can compare a large pool quickly and fairly.
Results arrive ranked by skill, with no manual marking.
Proctoring flags unusual activity and gives every candidate a trust score.

The Template
Three core tests for everyday admin work, plus one spreadsheet test for Microsoft 365 or Google Workspace. Add extra tests for busier or more senior roles.
Core
Data entry, email management, basic file management and time management.
Beginner
Core
Email basics and etiquette, Microsoft Outlook, and handling virtual meetings and appointments.
Beginner
Core
Creating and formatting documents, inserting elements, page layout, styles, and reviewing and proofing.
Beginner
Pick one spreadsheet
Data entry, formatting and validation, formulas and functions, analysis and charts.
Intermediate
Pick one spreadsheet
Data entry and validation, core formulas, analysis and charts, and collaboration tools.
Intermediate
Optional add-on
Telling urgent from important, handling competing requests and pushing back when needed.
Intermediate
Optional add-on
Proofreading, consistency checks, following a style guide and verifying data.
Intermediate
Optional add-on
Advanced formatting, collaboration tools, document automation, tables and complex layouts.
Advanced
Optional add-on
Grammar, vocabulary, reading and the functional language used in workplace communication.
Intermediate
Role Skills
The top skills for an administrative assistant are communication, organisation, scheduling, office software and attention to detail. This administrative assistant skills test scores each one.
Writing clear, professional emails and handling calls and messages politely.
Juggling competing requests and knowing what needs doing first.
Managing calendars, booking meetings and keeping appointments on track.
Creating documents and keeping spreadsheets accurate and tidy.
Spotting errors in documents, data and bookings before they cause problems.
Entering information accurately and keeping files easy to find.
From a pile of applications to a short list of organised, capable assistants, in four steps.

Start with four tests built for everyday office work.

Pick Microsoft Excel or Google Sheets, add any extra tests, and add your own questions.

Share one link with your whole applicant pool, or send it from your ATS.

Shortlist the candidates who scored best and spend interview time only on them.
Every result breaks down by skill, so you know who is great with email but needs support with spreadsheets.

Understand
See admin, email, Word and spreadsheet scores separately, not one blended number.

Compare
Rank a large applicant pool on the same skills in seconds.

Review
Open each answer to see how a candidate handled a real office task.

By Role Type
Start from the same template and adjust it to the role, or jump to the ready-made test for a related job.
Use the full template and add Prioritization for roles that run the office day to day.
Add Microsoft Word (Advanced) and Prioritization for roles that support senior leaders.
Keep Email Skills and Administrative Support, and add English B2 for customer-facing roles.
Pick Google Sheet if the team works in Google Workspace, and add Prioritization.
Add Attention to Detail and a typing test for roles with lots of data entry.
Keep the three core tests and set a lower passing score.
Got questions
Use the administrative assistant test template free for 7 days. No credit card required.
“We tried different platforms, but TestTrick was the only one that met the requirements.”
Sajjad Ahmed - Head of Talent at Trillium Information Security Systems
