Administrative Assistant Test

TestDome skill assessments are used by more than 8,000 companies and 880,000 test takers.

For Jobseekers

Practice your skills and earn a certificate of achievement when you score in the top 25%.

Take a Practice Test

For Companies

Test candidates with real-world problems and interview the best ones.

Sign Up to Offer this Test

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

Easy
1 min
mcq
Public
Logical Reasoning
Zero-Sum Thinking

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?

Easy
3 min
num
Public
Numerical Reasoning
Linear Equations

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

Easy
3 min
mcq
Public
Verbal Reasoning
Most Effective Summary

An author writes an argumentative essay to persuade readers to agree with a claim about a topic. When writing an argumentative essay, it's important to establish credibility with readers to convince them that the author is trustworthy. True statements, accurate evidence, and clear logic increase an author's credibility. However, false statements, inaccurate evidence, and unclear logic make an author less credible. With lower credibility, an author is less likely to persuade readers to agree with a claim--even when it is trustworthy.

Select the statement that most effectively summarizes the above text:

Easy
2 min
mca
Public
Attention to Detail
Identifying Mistakes

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?

Easy
7 min
filev
Public
MS Excel
Cell References
Formulas and Functions

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 base price 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.

Easy
2 min
mca
Public
Interpersonal Skills
Customer Service

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?

Easy
3 min
mca
Public
Written Communication
English Language
Grammar and Punctuation

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?

Easy
3 min
mmcq
Public
Time Management
Benchmarks
Prioritization

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
TOTAL 40
Easy
2 min
mca
Public
Time Management
Competing Schedules
Scheduling

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?

Easy
10 min
filev
Public
MS Excel
Data Filtering
Data Management

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.

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

Sunshine Caprio

Java and SQL
TestDome
Certificate
TestDome logo icon

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

117 more premium Administrative Assistant questions

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

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
  • Linear Equations
  • Mechanics
  • Divide and Conquer
  • Double Counting
  • Gambler's Fallacy
  • Affirming a Disjunct
  • Deductive Reasoning
  • Fallacy of Division
  • Set Theory
  • Circular Reasoning
  • Fallacy of the Undistributed Middle
  • Fallacy of Exclusive Premises
  • Critical Thinking
  • Existential Fallacy
  • Modal Fallacy
  • Illicit Major
  • Understanding Rules
  • Interpersonal Skills
  • Customer Service
  • True Statement
  • Fallacy of Composition
  • MS Excel
  • Formulas and Functions
  • Data Filtering
  • Data Management
  • Data Sorting
  • Data Lookup
  • Angry Customer
  • Call Center
  • Customer Complaint
  • Return Request
  • Process Improvement
  • Correlation and Causation
  • Geometry
  • Attention to Detail
  • Verifying Data
  • Bar Chart
  • Charting
  • Table Lookup
  • Alphabetical Order
  • Following Instructions
  • Identifying Mistakes
  • Proofreading
  • Exact Match
  • Affirming the Consequent
  • Masked-Man Fallacy
  • Argument from Fallacy
  • Conjunction Fallacy
  • Arithmetic
  • Basic Math
  • Visual Attention
  • Written Communication
  • Email Etiquette
  • English Language
  • Grammar and Punctuation
  • Tone and Voice
  • Clear and Concise
  • Giving Instructions
  • Time Management
  • Prioritization
  • Reordering Tasks
  • Vacation Policies
  • The 4Ds
  • Finding Availability
  • Scheduling
  • Assigning Work
  • Competing Schedules
  • Project Timeline
  • Pivot Tables
  • Data Labels
  • Pie Chart
  • Conditional Formulas
  • INDEX MATCH
  • Two-Dimensional Lookup
  • Date Functions
  • Advanced Filter Tool

For job roles

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

Sample candidate report

What others say

Decorative quote

Simple, straight-forward technical testing

TestDome is simple, provides a reasonable (though not extensive) battery of tests to choose from, and doesn't take the candidate an inordinate amount of time. It also simulates working pressure with the time limits.

Jan Opperman, Grindrod Bank

Product reviews

G2 High Performer 2022G2 Read Our Reviews

Used by

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.

90+ skills

From JavaScript and SQL to English and customer support. See all questions to filter by skill.

Multi-skills Test

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

How TestDome works

1

Choose a pre-made test
or create a custom test

2

Invite candidates via
email, URL, or your ATS

3

Candidates take
a test remotely

4

Sort candidates and
get individual reports

Want to know more?