This Administrative Assistant Online Test
Separates Good From Bad Hires

Screen with work-sample questions

Work-samples are the best predictor of work performance. 8,000+ companies use TestDome premium questions.

About the test

The Administrative Assistant test evaluates candidates’ competency in attention to detail, basic Excel spreadsheets, time management, written communication, and interpersonal skills, as well as their general aptitude for logical, numerical, and verbal reasoning.

It’s an ideal test for pre-employment screening of candidates applying for office-based clerical roles, such as administrative assistants, receptionists, secretaries, and office coordinators. A good candidate for an administration assistant job will be able to display a high level of interpersonal skills, excellent written communication, competency with basic spreadsheet usage, the ability to prioritize their work, proficiency in scheduling tasks for themselves and others, thoroughness in detail-oriented work, an aptitude for understanding numerical information, thorough comprehension of written information presented in reports and emails, and the ability to make logical conclusions about facts and figures.

This test requires candidates to demonstrate their abilities by performing assignments in spreadsheet software as well as answering a series of multiple-choice and fill-in-the-blank questions. Candidates can use either their personal copy of Microsoft Excel or the free web version of Excel to complete the test.

Sample public questions

An eagerly awaited new album has been leaked several hours before its official release. Listeners are now able to download the album for free.

How will this affect album sales?

Logical Reasoning
Zero-Sum Thinking
1 min

How old is John if, in 38 years, he will be 3 times as old as he is today?

Numerical Reasoning
Linear Systems
3 min

When writing an argumentative essay, it's very important to establish credibility with the audience. Providing inaccurate or false information is a surefire way to lose credibility with the reader. Once the essay’s credibility is lost, the reader will be less likely to believe other statements even if they are backed up by facts.

Select the statement that most effectively summarizes the above text:

Verbal Reasoning
Most Effective Summary
2 min

Your staff has submitted the two reports below, which cover the sales and bonus data for seven employees.

Two reports containing the staff sales and their bonuses

Which employees have different information listed between the reports?

Attention to Detail
Identifying Mistakes
2 min

Your company sells products to customers in two cities, New York and San Francisco. You have been asked to calculate each product’s retail prices inclusive of sales taxes in these cities.

Specifically, you need to:

  • Write formulas to calculate the retail prices, inclusive of sales tax, using the net prices of each product.
  • Make sure you reference cells A5 and B5 in your formulas.

Note: Do not use array formulas in your work.

Your task is to download the file ‘TaxInclusive-RawData.xlsx’ file and execute the request. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.

MS Excel
Formulas and Functions
10 min

An elderly customer calls with a problem finding some product information on your company’s website. He is nice enough, just frustrated and hopeless because he can’t find what he needs. The information he’s looking for is too long and complicated to share over the phone. What are the best next steps?

Interpersonal Skills
Customer Service
2 min

You are working as a social media manager for a company that has specific expectations of how you will perform your work.

A pie graph titled 'Expectations for Time Spent in Role'

Compare those expectations with how you actually spent your time last week.

Function Hours Worked
Customer Support 10
Creative Design 18
Managing Freelancers 4
Marketing Analytics 4
Other (Meetings, etc.) 4
Time Management
3 min

You’re available from 9:30am to 2:00pm.

Angela is available from 10:30am to 2:30pm.

Chris is available from 12pm to 4pm.

When are all three of you available for a one-hour meeting?

Time Management
2 min

You drafted an email on your phone in poor lighting while in transit. Now back in the office, you need to proofread what you wrote before sending it out. Read the email draft below.

The agenda for next week’s meeting includes presentations from both the marketing and sales teams. Marisol, you will need to has completed the analysis of the most recent campaign by then. You guys need to present slides of those outcomes at the meeting, OK? Meanwhile, Lucas should do something similar for the sales team. Rather than presenting individual case studies, tries to analyze the quarter as a whole this time. Let's nail these presentations and show the executives how much improvement we have made?

Which sentences have errors in grammar or punctuation?

Written Communication
English Language
Grammar and Punctuation
3 min

Your company’s accounting department has asked you to give them a list of orders filtered by two periods of time:

  • On 'Sheet1', they need orders spanning a two-month period (from the 1st of July, 2018, to the 31st of August, 2018).
  • On 'Sheet2', they need all orders for the period before the 1st of July, 2018, and all orders for the period after the 31st of August, 2018.

Your task is to download the file 'TimeFilters-RawData.xlsx’ file and execute this request. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.

MS Excel
Data Filtering
Data Management
10 min

For jobseekers: get certified

Earn a free certificate by achieving top 25% on the Administrative Assistant test with public questions.

Take a Certification Test

Sample silver certificate

Kera Lafleur

Java and SQL


TestDome logo on certificate

For companies: premium questions

Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.

Sign Up to Offer this Test

118 more premium Administrative Assistant questions

  Revenue No Growth,   Tax,   Uber,   Drawing the Next Card,   Revenue Growth,   Life Expectancy,   Business Reports,   Broken Clock,   Parrots,   Gas Price,   Swimming Pool,   Employees to Digits,   Traffic Counter,   Pages,   Ears,   Profits,   Gas Price Change,   Digits to Employees,   Fruit Juice Processing,   Penny Flipping,   World Championship,   Elementary School,   Kindergarten,   Alarm System,   Game Rules,   Bikers,   Riviera Hotels,   Masked Burglar,   Math Courses,   Middle Ages Warlords,   Profit Margin,   Race Track,   Road Trip,   Thief,   Digital Ads,   Holidays,   Money,   Workplace,   All-Stars,   Customer Parking,   Working Week,   Fossil Dig,   Vacation Days,   Lucky Roller,   Elves,   Product Defect,   Angry Jones,   Service Failure,   Critical Client,   Traffic Tickets,   Blue-collar Workers,   Renewable Energy,   Refund Demand,   Flower Exports,   Too Many Tasks,   Event Booking,   Restaurant Meeting,   Busy Intersection,   Report Distribution,   Conference Instructions,   Training Session,   Billable Hours,   Pages Turned,   Condominium,   Football Stadium Renovation,   Candidate Answers,   Money,   Currency Conversion,   Order Display,   Aussie Freight,   Product Lookup,   Large Orders,   Hot Beverage Filters,   Mold,   Intern Design,   Cancelled Customer,   Eco Refrigerator,   Avoiding Calls,   File Encryption,   Red Black Chart,   Clock Hands,   Gear Wheels,   Olive Oil Press,   Clock Angles,   Brainstorming Session,   License Match,   Seating Plan,   Expense Management,   Region Code,   Industry Sectors,   Text to Code,   Eye Color,   Cooking Oil,   Discount,   Break,   Free Calls,   Plans,   Document Organization,   Sales Flights,   Email Dictation,   Sunscreen Ingredients,   Hair Products,   Food Additive,   Work to Finish,   Company Rules,   Reversed Accounts,   Automatic Entries,   Inventory Count,   Project Hours,   Daily Tasks,   Vacation Requests,   Holiday Brochures,   Whitepaper Estimate,   Busy Schedule,   Assign Staff,   Regional Sales,   Overdue Invoices,   Five Year Sales.

Skills and topics tested

  • Numerical Reasoning
  • Chart Lookup
  • Percentages
  • Verbal Reasoning
  • Most Effective Summary
  • Newspaper Excerpts
  • Logical Reasoning
  • Non-Independent Events
  • Inductive Reasoning
  • Attribute Substitution
  • Arithmetic
  • Linear Systems
  • Mechanics
  • Divide and Conquer
  • Double Counting
  • Gambler's Fallacy
  • Affirming a Disjunct
  • Deductive Reasoning
  • Fallacy of Division
  • Set Theory
  • Affirming the Consequent
  • Circular Reasoning
  • Fallacy of the Undistributed Middle
  • Critical Thinking
  • Masked-Man Fallacy
  • Fallacy of Exclusive Premises
  • Argument from Fallacy
  • True Statement
  • Fallacy of Composition
  • Existential Fallacy
  • Modal Fallacy
  • Illicit Major
  • Understanding Rules
  • Interpersonal Skills
  • Customer Service
  • Correlation and Causation
  • Prioritization
  • Time Management
  • Scheduling
  • Conjunction Fallacy
  • Written Communication
  • Email Etiquette
  • Clear and Concise
  • Giving Instructions
  • English Language
  • Grammar and Punctuation
  • Tone and Voice
  • MS Excel
  • Formulas and Functions
  • Data Filtering
  • Data Management
  • Data Sorting
  • Data Lookup
  • Attention to Detail
  • Identifying Mistakes
  • Visual Attention
  • Angry Customer
  • Call Center
  • Customer Complaint
  • Return Request
  • Process Improvement
  • Geometry
  • Exact Match
  • Verifying Data
  • Bar Chart
  • Charting
  • Table Lookup
  • Alphabetical Order
  • Following Instructions
  • Basic Math
  • Proofreading
  • Pie Chart
  • Pivot Tables

For job roles

  • Administrative Assistant
  • Executive Assistant
  • Manager
  • Office Coordinator
  • Receptionist
  • Secretary

Solve all your skill testing needs

150+ Pre-made tests

From web development and database administration to project management and customer support. See all pre-made tests.

Multi-skills Test

Mix questions for different skills or even custom questions in one test. See an example.

How TestDome works

Choose a pre-made test or create a custom test.
Invite candidates via email, URL or your ATS
Candidates take a test remotely
Sort candidates and get individual reports

Want to know more?