Administrative Assistant Test
For Jobseekers
Practice your skills and earn a certificate of achievement when you score in the top 25%.
Take a Practice TestFor Companies
Test candidates with real-world problems and interview the best ones.
Sign Up to Offer this TestAbout 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
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.
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?
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.)
Which of the passwords are the same as the mirrored images?
After saving for years, John's parents bought him his first car for his birthday. He was so happy that they decided to keep buying him cars on future birthdays that came after the same interval of years.
Today they bought him yet another car—38 years after the first.
Here are the birthday cars.
How old was John when he got his first car from his parents?
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.
You are working as a social media manager for a company that has specific expectations of how you will perform your work.
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 |
You need to schedule a critical meeting. 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.
Everyone hates meeting during lunch but will if it's important.
When are all three of you available to start a one-hour meeting?
In the summer, Agathe wore an ill-fitting sun hat and oversized sunglasses to the beach in Greece. Both slipped off when she fell asleep in her swimsuit on the beach at 2 p.m.
What will most likely happen to Agathe?
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?
For jobseekers: get certified
Earn a free certificate by achieving top 25% on the Administrative Assistant test with public questions.
Take a Certification TestSample silver certificate
Sunshine Caprio
Java and SQL TestDomeCertificate
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.
122 more premium Administrative Assistant questions
Life Expectancy, Product Defect, Angry Jones, Renewable Energy, Document Organization, Report Distribution, Holiday Brochures, Event Booking, Project B, Restaurant Meeting, Workplace, Customer Parking, Math Courses, Blue-collar Workers, Candidate Answers, Road Trip, Kindergarten, Penny Flipping, Elementary School, World Championship, All-Stars, Masked Burglar, Employees to Digits, Clock Angles, Plans, Free Calls, Broken Clock, Digits to Employees, Pages Turned, Olive Oil Press, Discount, Gear Wheels, Seating Plan, Reversed Accounts, License Match, Hair Products, Intern Design, Eye Color, Sunscreen Ingredients, File Encryption, Inventory Count, Food Additive, Drawing the Next Card, Red Black Chart, Traffic Tickets, Business Reports, Profits, Revenue Growth, Starfish, Outdoor Tub, Traffic Counter, Sales Flights, Text to Code, Brainstorming Session, Whitepaper Estimate, Critical Client, Service Failure, Uber, Digital Ads, Money, Holidays, Tax, Cooking Oil, Project Hours, Work to Finish, Company Rules, Refund Demand, Cancelled Customer, Eco Refrigerator, Avoiding Calls, Regional Sales, Aussie Freight, Hot Beverage Filters, Region Code, Expense Management, Currency Conversion, Industry Sectors, Product Lookup, Five Year Sales, Too Many Tasks, Constant Change, Vacation Requests, Busy Schedule, Middle Ages Warlords, Football Stadium Renovation, Vacation Days, Riviera Hotels, Conference Instructions, Training Session, Billable Hours, Flower Exports, Clock Hands, Marbles, Race Track, Pages, Break, Large Orders, Overdue Invoices, Order Display, Ears, Spin the Wheel, Currency Exchange, Automatic Entries, Email Dictation, Daily Tasks, Thief, Alarm System, Condominium, Working Week, Game Rules, Fossil Dig, Bikers, Elves, Mold, Lucky Roller, Laptop Setup, Gas Price, Gas Price Change, Profit Margin, Revenue No Growth, Busy Intersection, Fruit Juice Processing.
Skills and topics tested
- Verbal Reasoning
- Inductive Reasoning
- Interpersonal Skills
- Customer Service
- True Statement
- Attention to Detail
- Alphabetical Order
- Following Instructions
- Written Communication
- Email Etiquette
- Time Management
- Prioritization
- Reordering Tasks
- Finding Availability
- Scheduling
- Assigning Work
- Logical Reasoning
- Deductive Reasoning
- Fallacy of the Undistributed Middle
- Existential Fallacy
- Modal Fallacy
- Fallacy of Exclusive Premises
- Fallacy of Division
- Fallacy of Composition
- Set Theory
- Gambler's Fallacy
- Affirming a Disjunct
- Masked-Man Fallacy
- Numerical Reasoning
- Divide and Conquer
- Geometry
- Working with Time
- Linear Equations
- Table Lookup
- Arithmetic
- Mechanics
- Verifying Data
- Exact Match
- Identifying Mistakes
- Visual Attention
- Basic Math
- Dependent Events
- Probability
- Correlation and Causation
- Attribute Substitution
- Chart Lookup
- Percentages
- Competing Schedules
- Project Timeline
- Customer Complaint
- Angry Customer
- Most Effective Summary
- Newspaper Excerpts
- Call Center
- Return Request
- Process Improvement
- MS Excel
- Charting
- Data Labels
- Pie Chart
- Formulas and Functions
- INDEX MATCH
- Two-Dimensional Lookup
- Advanced Filter Tool
- Data Filtering
- Data Management
- Exclusion Criteria
- Cell References
- Bar Chart
- Chart Axes
- Match Type
- VLOOKUP
- Field Groups
- Pivot Tables
- The 4Ds
- Vacation Policies
- Critical Thinking
- Understanding Rules
- Clear and Concise
- Giving Instructions
- English Language
- Grammar and Punctuation
- Tone and Voice
- Fractions
- Conditional Formulas
- Data Sorting
- Date Functions
- Rotating Elements
- Proofreading
- Argument from Fallacy
- Affirming the Consequent
- Double Counting
- Circular Reasoning
- Illicit Major
- Work Rate
- Conjunction Fallacy
For job roles
- Administrative Assistant
- Executive Assistant
- Manager
- Office Coordinator
- Receptionist
- Secretary
Sample candidate report
What others say
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
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
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