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?
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:
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 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.)
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?
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?
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?
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?
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 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.
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
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