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
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
2 min
mca
Public
Logical Reasoning
Appeal to Probability

It has rained continuously for 15 days. Tomorrow, an important football match is being held in an outdoor stadium.

Select which of the following statements are true:

Easy
10 min
fill
Public
Verbal Reasoning
Deductive Reasoning
Understanding Rules

The company's sick leave policy says:

This company’s sick leave policy applies to all our employees who have been with our company for more than six months. Our employees can take sick leave only when they want to recover from a sudden illness, accident, or injury. They can use up to 10 days of sick leave for these purposes per calendar year.

Upon completion of each 12 month period of employment, employees will receive 3 additional days of sick leave for every completed 12 month period of working for the company. Unspent additional sick leave days cannot be transferred to the next 12 month period. For example, an employee who has worked for the company for 10 years would receive 30 additional days of sick leave, or 40 in total.

Keep in mind that employees who become sick should either use their sick days or work from home to avoid spreading illnesses.

Fill in the blanks, with numbers, for the cases below. Enter the number 0 for cases when an employee doesn't have the right to sick leave, according to the policy.

  • Emily, who has worked for us for almost half a year and still hasn't used any sick leave days, has the right to use up to __ sick leave days this year.
  • Faith, who just started her 3rd year of working for us and has not taken sick leave until now, had a car accident. She has the right to use up to __ days of sick leave to recover from her injuries.
  • Vanessa, who started to work for us a little over a year ago, took 2 days of sick leave last year. She was Faith's passenger in the car accident. Vanessa has the right to use up to __ days of sick leave to recover from her injuries.
  • Edith, who began working for us 8 months ago, has the right to use up to __ sick leave days for a volunteer adult care program at a local hospital that lasts the whole day.
  • If Gabrielle, who has worked for us for 20 months, and who took a 10-day sick leave immediately after her 6-month trial period had finished, gets ill tomorrow, she will have the right to use up to __  days of sick leave.
Hard
5 min
num
Public
Time Management
Arithmetic
Prioritization

You have partially planned your tasks for tomorrow, as shown in the table below.

Task Duration of Task # of Tasks Planned
Response to client. 8 minutes  
Identify expansion opportunity. 2 hours 50 minutes 2
Develop sales presentation. 1 hour 15 minutes 1

Given 8 hours of work and the tasks you already have planned, how many responses to clients can you plan for tomorrow?

(Round your answer to the nearest integer.)

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?

Hard
3 min
mca
Public
Attention to Detail
Exact Match
Verifying Data

While training to be a workplace investigator, you are taught to read mirrored writing so you can read a suspect's monitor that is facing away from you when there is a window or mirror behind it. To test your skill, you are asked to compare a list of passwords to a list of mirrored images.

(Open full-size image in a new tab.)

Passwords and their Mirrored Images

Which of the passwords are the same as the mirrored images?

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
num
Public
Numerical Reasoning
Table Lookup

Five types of tires were tested in three different driving conditions.

Consider the following table of their test scores:

Tire Type Driving Condition Test Scores
Dry Wet Snow
Desert 10 4 1
Beach 5 8 5
Mountain 6 9 6
Swamp 7 10 4
Jungle 7 5 6

If a tire type scored 4 or less in any category, it failed the test.

What is the highest average score of the tire types that passed the test?

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

118 more premium Administrative Assistant questions

Revenue No Growth, Tax, Uber, Life Expectancy, Parrots, Swimming Pool, Employees to Digits, Traffic Counter, Pages, Ears, Digits to Employees, Bikers, Middle Ages Warlords, Profit Margin, Race Track, Customer Parking, Fossil Dig, Vacation Days, Elves, Product Defect, Angry Jones, Service Failure, Critical Client, Renewable Energy, Refund Demand, Flower Exports, Pages Turned, Currency Conversion, Order Display, Product Lookup, 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, 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, Constant Change, Thief, Alarm System, Workplace, Drawing the Next Card, Condominium, Math Courses, Business Reports, Traffic Tickets, Working Week, Blue-collar Workers, Game Rules, Candidate Answers, Road Trip, Penny Flipping, Kindergarten, Mold, Elementary School, Lucky Roller, World Championship, Fruit Juice Processing, Busy Intersection, All-Stars, Masked Burglar.

Skills and topics tested

  • Numerical Reasoning
  • Chart Lookup
  • Percentages
  • Verbal Reasoning
  • Most Effective Summary
  • Newspaper Excerpts
  • Inductive Reasoning
  • Linear Equations
  • Mechanics
  • Divide and Conquer
  • Logical Reasoning
  • Deductive Reasoning
  • Fallacy of the Undistributed Middle
  • Critical Thinking
  • Existential Fallacy
  • Modal Fallacy
  • Illicit Major
  • Understanding Rules
  • Attribute Substitution
  • Interpersonal Skills
  • Customer Service
  • True Statement
  • 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
  • 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
  • Argument from Fallacy
  • Affirming the Consequent
  • Non-Independent Events
  • Fallacy of Composition
  • Fallacy of Exclusive Premises
  • Double Counting
  • Fallacy of Division
  • Circular Reasoning
  • Gambler's Fallacy
  • Set Theory
  • Affirming a Disjunct
  • Conjunction Fallacy
  • Masked-Man Fallacy

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 - Crowd Badge
G2 - High Performer (2022)
Capterra - 4.5 Stars
Capterra - Shortlist (2022)

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?