Admin assistant skills test for hiring (questions, scoring rubric, benchmarks)

What to screen for when hiring an admin assistant

Hiring an admin assistant? The resumes will all say the same things: organized, detail-oriented, proficient in Excel. A short skills test shows you which candidates actually are, before you spend interview time finding out the hard way. This page gives you the full screen: the skill areas that matter, a role-weighted blueprint, 10 scenario questions with answers and rationale, work-sample rubrics, and score bands tied to a hiring decision.

It works for the admin roles a small business hires most: administrative assistant, office coordinator, executive assistant (with weighting adjustments), and receptionist (with a front-desk module). For the rest of the process, job description included, see the guide to hiring an administrative assistant.

Skill model (core domains)

Attention to detail and data accuracy

• Detecting errors in names, dates, amounts, attachments, and versioning
• Following instructions precisely under time pressure

Prioritization and execution (time management)

• Sorting urgent vs. important
• Managing dependencies and deadlines
• Escalation judgment (when to ask vs. act)

Business communication (email and written clarity)

• Professional tone and concision
• Clear asks, summaries, and next steps
• Correct grammar and audience-appropriate messaging

Scheduling and calendar management (including time zones)

• Resolving conflicts, constraints, and meeting logistics
• Remote/hybrid etiquette (agenda, links, RSVP expectations)

Spreadsheet readiness (Excel / Google Sheets)

• Sorting and filtering without breaking records
• Basic formulas (SUM, COUNTIF/COUNTIFS, IF)
• Data cleanliness (duplicates, formatting, validation)

Confidentiality, integrity and compliance mindset

• Handling sensitive information (HR, finance, client data)
• Recognizing red flags (misdirected emails, phishing, improper access)

Customer service and professionalism

• Stakeholder management, responsiveness, tact under pressure

Role-level calibration (what changes by seniority)

• Junior admin: heavier weight on accuracy, instructions, basic communication, and tool fundamentals
• Administrative assistant: balanced weighting across execution, scheduling, and business writing
• Executive assistant: increased complexity in prioritization, confidentiality, and stakeholder management; more ambiguous scenarios

How the test is designed

To go beyond a generic quiz, this screen uses a multi-method approach:

Job knowledge and tool skills (structured items)

Covers spreadsheet basics, document hygiene, simple math and data handling.
Format: multiple-choice / multiple-select.

Situational judgment scenarios (SJTs)

Surfaces how candidates approach prioritization, confidentiality, customer service, and escalation.
Format: best/least effective responses or ranked options, scored against the approach you want on your team.

Work-sample mini tasks (optional but strongly recommended)

Shows real performance in realistic admin workflows.
Format: a short email rewrite, a calendar conflict resolution, a spreadsheet cleanup.

Why this approach holds up

• Job-relatedness: scenarios mirror real admin tasks
• Consistency: same time limits and scoring for every candidate
• Transparency: clear skill areas and interpretation guidance
• Fairness controls: structured scoring reduces subjective variance

Hiring note (U.S.): selection tools are strongest when they are job-related and applied consistently. Consult your HR or legal advisor for guidance specific to your role and jurisdiction.

Recommended test structure

Use this as a turnkey configuration.

Version A: fast screen (35 to 45 minutes)

• 8 to 10 min: attention to detail and data accuracy
• 10 to 12 min: scenario judgment (prioritization/confidentiality)
• 10 to 12 min: Excel/Sheets essentials
• 7 to 9 min: business email clarity

Version B: full assessment (60 to 90 minutes, best for finalists)

Everything in Version A plus:

• 15 to 20 min: inbox triage + calendar conflict work sample
• 10 to 15 min: spreadsheet cleanup work sample

Suggested skill weighting (administrative assistant)

• Attention to detail and accuracy: 20%
• Prioritization and execution: 20%
• Communication (email): 15%
• Scheduling and time zones: 15%
• Excel/Sheets: 15%
• Confidentiality and integrity: 10%
• Customer service and professionalism: 5%

Adjustments by role

• Receptionist: shift +10% into customer service; reduce Excel
• Executive assistant: shift +10% into prioritization/confidentiality; increase ambiguity and stakeholder complexity

The test: 10 questions with answers and rationale

Use these as the core of your screen. In production, randomize order and rotate an item bank.

1) Attention to detail (names + meeting details)

Context: The candidate is scheduling a meeting requested by "Alicia Chen" for Thu, April 18 at 2:30 PM ET. Their draft reads: "Hi Alisha, confirmed for Friday 4/18 at 2:30pm."

Question: Identify all errors.

A. Name misspelling
B. Wrong day of week
C. Wrong date format
D. Wrong time zone

Correct answer: A, B

Why it's included: small mismatches create rework and erode trust with the people your assistant emails on your behalf. This checks detail discipline.

2) Situational judgment: prioritization under competing deadlines

Context: It's 9:05 AM. The manager messages: "Need the board deck printed by 10:30." At 9:07, the CFO emails: "Can you confirm today's 2 PM client call details?" At 9:08, reception calls: "A visitor arrived early and says they have a 9:30 interview."

Question: What is the best first action?

A. Start printing the board deck immediately; everything else can wait.
B. Ask reception to seat the visitor and confirm the interviewer is en route; then validate board deck print requirements.
C. Reply to the CFO first to show responsiveness.
D. Tell reception the visitor should wait outside until 9:30.

Correct answer: B

Rationale: the candidate stabilizes the time-sensitive human experience through delegation, then quickly verifies board-deck requirements to avoid misprints. The CFO confirmation can follow shortly after.

3) Confidentiality and judgment: misdirected email

Context: The candidate receives an email from HR with an attachment labeled "Comp_Adjustments_Q2.xlsx." It appears to include salary data. The email was addressed to them, but they weren't expecting it.

Question: What should they do first?

A. Open it to see whether it's relevant to their tasks.
B. Forward it to their manager to ask what to do.
C. Reply to HR confirming whether it was intended for them; do not open or share until confirmed.
D. Save it to a shared drive so the team can access it if needed.

Correct answer: C

Rationale: this protects confidentiality and limits distribution. On a small team, your assistant will see sensitive information. This question shows whether they treat it that way.

4) Excel/Sheets: safe sorting

Context: Column A has employee names, Column B has extension numbers, Column C has departments. The candidate needs to sort by department.

Question: What is the safest method to avoid mismatching names and extensions?

A. Sort only Column C.
B. Highlight all data columns and sort the entire range by Column C.
C. Copy Column C to a new sheet and sort it.
D. Sort Column A first, then Column C.

Correct answer: B

5) Excel/Sheets: COUNTIF/COUNTIFS logic

Context: The candidate tracks meeting RSVPs. Column A = Email, Column B = Status (Yes/No/Maybe). They need the count of "Yes."

Question: Which formula is correct?

A. =COUNT(B:B,"Yes")
B. =COUNTIF(B:B,"Yes")
C. =SUMIF(B:B,"Yes")
D. =COUNTIFS(A:A,"Yes")

Correct answer: B

6) Business email: clarity and action

Context: A vendor wrote: "We didn't receive your signed W-9. Please send ASAP." The candidate has it.

Question: Choose the best reply.

A. "Attached."
B. "Hi, please see attached W-9. Let me know if you need anything else."
C. "Hello, attached is the signed W-9. Please confirm receipt. If you require an updated address or tax classification, I can provide it."
D. "I already sent it last week. Check your inbox."

Correct answer: C

7) Scheduling across time zones

Context: The candidate must schedule a 45-minute meeting with three people:

• Alex: available 9:00–11:30 AM PT
• Priya: available 1:00–4:00 PM ET
• Sam: available 2:00–5:00 PM CT

Question: Which meeting time works for all? (Choose one)

A. 10:00 AM PT
B. 11:00 AM PT
C. 1:30 PM ET
D. 2:30 PM CT

Correct answer: B

Work: 11:00 AM PT = 2:00 PM ET = 1:00 PM CT.

8) Proofreading: instruction-following

Context: Instruction: "Reply-all to confirm attendance and include the meeting ID in the first line." Draft: "Sounds good, see you then."

Question: What's missing?

A. A greeting
B. The meeting ID in the first line
C. A calendar attachment
D. A signature

Correct answer: B

9) Situational judgment: handling a competing executive request

Context: The candidate supports a director. The CEO's assistant asks them to "quickly" compile a list of the director's upcoming travel dates for the next 60 days. The director is in a client meeting and asked not to be interrupted unless urgent.

Question: Best response?

A. Interrupt the director to confirm travel plans.
B. Send the CEO's assistant a best guess.
C. Use the calendar to compile confirmed travel blocks, label them as "calendar-confirmed," and offer to validate any tentative items after the meeting.
D. Decline and say they only support their director.

Correct answer: C

10) Integrity: expense handling red flag

Context: A manager asks the candidate to "code this dinner as office supplies so finance won't ask questions."

Question: What should they do?

A. Do it, since the manager instructed them.
B. Ask finance what the best workaround is.
C. Explain they can't miscode expenses; offer correct categories and the documentation needed.
D. Ignore the request.

Correct answer: C

Rationale: this is the question to weight heavily if your assistant will touch expenses, invoices, or anything finance-adjacent. There's no partial credit on integrity.

Scoring rubric

Point model

Use 100 points total for easy interpretation.

• Structured items (detail, Excel, rules): 60 points
  • 1 point each (or 2 points for higher-difficulty items)
• Scenario judgment items: 25 points
  • Best answer: full credit
  • Second-best: partial credit (50 to 70%) if defensible
• Work samples (email rewrite, scheduling, spreadsheet cleanup): 15 points
  • Rubric-scored (below)

Work-sample rubrics (anchored criteria)

Email rewrite (0 to 5 points)

• 5: concise, correct tone, clear ask and next step, confirms key details, no errors
• 3: understandable but wordy or missing a key detail (deadline/ask)
• 1: unclear, unprofessional, or introduces risk

Calendar resolution (0 to 5 points)

• 5: resolves conflicts, respects constraints, includes location/link/agenda, confirms time zones
• 3: correct time but missing logistics or leaves a conflict unresolved
• 1: incorrect availability or a time zone error

Spreadsheet cleanup (0 to 5 points)

• 5: preserves row integrity, correct sort/filter, removes duplicates appropriately, uses validation
• 3: mostly correct but minor integrity risk (partial range selection, for example)
• 1: corrupts the dataset or cannot explain the steps

Integrity controls (practical)

• Randomize items; rotate an item bank
• Set time limits per section
• Use at least one work sample that requires original output
• For remote testing, consider verification methods (a short live follow-up, or proctoring with candidate notice and consent), consistent with your policy and applicable laws

Fairness and accommodations

• Tell candidates the estimated time, tool requirements, and whether outside resources are allowed
• Offer reasonable accommodations (extra time, assistive tech) when appropriate
• Keep scenarios job-relevant and avoid culture-specific trivia

What scores mean for your hiring decision

Use these bands as a starting benchmark, then refine using your own hiring outcomes.

85–100: strong (ready now)

What it suggests:

• Reliable accuracy under time pressure
• Sound judgment on prioritization and confidentiality
• Tool competence that won't slow the team

Next step: move to a final interview and reference checks, and validate any critical requirements.

70–84: solid (coach-ready)

What it suggests:

• Functional admin readiness with 1 or 2 gaps, most often Excel fluency or scenario judgment

Next step: consider moving forward; probe the weaker areas with structured interview questions and a targeted work sample.

55–69: borderline (higher oversight likely)

What it suggests:

• Inconsistent attention to detail or weaker prioritization
• Likely needs closer supervision at first

Next step: if the role allows training time, run a follow-up work sample focused on the weakest domain before deciding.

Below 55: needs development

What it suggests:

• Gaps likely to create errors, delays, or policy risk without support

Next step: for roles with limited ramp time, you may choose not to proceed. If you do proceed, use structured follow-ups and additional job-relevant work samples to validate skills first.

Benchmarks (what good looks like)

Practical benchmarks

• Attention to detail: 90%+ on structured accuracy items for mid-level admin roles
• Excel/Sheets basics: sorts and filters safely, uses COUNTIF/SUM without breaking ranges
• Scheduling: zero time zone errors; includes logistics (link/location, agenda, attendees)
• Writing: concise, professional, action-oriented messages with minimal grammar errors

Process benchmarks (hiring quality)

• Standardized administration, a consistent scoring rubric, and documentation
• Track pass rates and monitor for adverse impact using accepted screening diagnostics (selection-rate comparisons such as the 4/5ths rule)

Interview follow-ups by weak domain

When a candidate underperforms in one area, use structured probes instead of writing them off:

• Detail: "Walk me through your personal method to prevent calendar and time zone errors."
• Prioritization: "What's your escalation threshold when two leaders ask for 'urgent' help?"
• Confidentiality: "Describe how you handle misdirected sensitive information."
• Excel: "Explain how you sort a table without breaking row integrity."

Run this screen automatically with Truffle

An admin posting draws one of the biggest candidate piles in small-business hiring. Scoring this test by hand across that pile is exactly the kind of night work the test was supposed to save you from.

Truffle is a candidate screening platform that combines talent assessments with resume screening and one-way video interviews. Set up the admin assistant screen once: resume screening cuts the obvious mismatches, the assessment surfaces who is accurate and sound under pressure, and a one-way interview shows you the professionalism and tone the role runs on. AI scores every candidate against the criteria you set and shows the evidence behind every ranking. You make the call.

Start your free trial. 7 days, 30 credits, no card required.