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?
In an upcoming referendum, voters will be asked whether the minimum wage should be increased. Telephone polls of likely voters were conducted to predict what the result might be. All respondents were put into at least one of six categories based on profession and age: scientist, lawyer, hourly wage earner, small business owner, younger voter, older voter.
The opinion polls showed:
- A majority of voters are in favor of keeping the current minimum wage.
- A majority of scientists and lawyers supported a rise in the minimum wage.
- Younger voters are more inclined to support a rise in the minimum wage.
- Older voters tend to support no change.
- Hourly wage earners overwhelmingly supported a rise in the minimum wage.
- Small business owners were evenly split on the subject.
Select all the statements that can be concluded from the above text:
Your company has been working to add old paper invoices to their new digital system. You have been tasked with checking the implementation to ensure that the details from the paper copy have been entered into the new system accurately.
Compare each item in the list below to see if the version displayed on your screen matches the paper copy.
In the Match? column, choose Y if the items match or choose N if they do not match.
Match? | Item Type | Paper | Screen |
---|---|---|---|
_____ | Name | Bhuvana Ananathram | Bhuvana Anantharam |
_____ | Order # | ON821I84 | ON82I184 |
_____ | Order Total | USD 1,717,771.17 | USD 1,717,771.17 |
_____ | Discount Code | 8B5SGO2Z1IDO | 8B5SGO2Z1IDO |
_____ | Address | 1255 34th, 32356 | 1255 34th, 323S6 |
_____ | Tracking # | BRBR1L72Z68RZ27 | BRBR1L72Z6BRZ27 |
_____ | Account # | 7442830438Z | 7442830438Z |
_____ | SWIFT | SGSBALTX | SGSBALTX |
_____ | IBAN | FI3880399835179438 | F18803993835179438 |
_____ | Payment | ALL 1,717,771.17 | ALL 1,717,771.77 |
_____ | Payment Date | 11/05/2018 | 11/05/2018 |
_____ | Ticket # | 83i8R1171jDoO | 83j8RB1171jDoO |
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?
You are having a discussion with your friend about the apps you both use.
Every app your friend uses, you also use. Spreadsheet is the app you use the most. You don't use the Calculator app at all.
With regard to what’s written above, select which of the following statements are true.
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?
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 |
Your assistant attended several meetings on your behalf while you were out on sick leave. You need to include a summary of each meeting in your next team newsletter. For each meeting below, choose the clearest and most concise way to restate the key points your assistant compiled.
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.
127 more premium Administrative Assistant questions
Life Expectancy, Product Defect, Angry Jones, Document Organization, Report Distribution, Holiday Brochures, Event Booking, Project B, Restaurant Meeting, Workplace, 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, Reversed Accounts, License Match, Hair Products, Food Additive, Traffic Tickets, Business Reports, Profits, Revenue Growth, Outdoor Tub, Traffic Counter, Text to Code, Whitepaper Estimate, Critical Client, Service Failure, Cooking Oil, Project Hours, Work to Finish, Company Rules, Refund Demand, Cancelled Customer, Avoiding Calls, Regional Sales, Aussie Freight, Hot Beverage Filters, Currency Conversion, Industry Sectors, Five Year Sales, Too Many Tasks, Constant Change, Vacation Requests, Busy Schedule, Middle Ages Warlords, Football Stadium Renovation, Vacation Days, Conference Instructions, Training Session, Billable Hours, Clock Hands, Marbles, Race Track, Pages, Break, Large Orders, Overdue Invoices, Order Display, Ears, Currency Exchange, Daily Tasks, Thief, Alarm System, Condominium, Working Week, Game Rules, Fossil Dig, Bikers, Elves, Mold, Laptop Setup, Gas Price, Gas Price Change, Profit Margin, Revenue No Growth, Busy Intersection, Fruit Juice Processing, Turtles, Closed Deals, Snack, Spin the Wheel, Feature Usage, Riviera Hotels, Product Lookup, Uber, Renewable Energy, Flower Exports, Lucky Roller, Customer Parking, Sales Flights, Automatic Entries, Email Dictation, Eco Refrigerator, Digital Ads, Holidays, Tax, Money, Seating Plan, Intern Design, Eye Color, Sunscreen Ingredients, Inventory Count, Contractor Fee, Image Toolbar, Drawing the Next Card, Brainstorming Session, File Encryption, Red Black Chart, Expense Management, Region Code.
Skills and topics tested
- Verbal Reasoning
- Inductive Reasoning
- Interpersonal Skills
- Customer Service
- 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
- 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
- Exact Match
- Verifying Data
- Basic Math
- Correlation and Causation
- Attribute Substitution
- Chart Lookup
- Percentages
- Project Timeline
- Customer Complaint
- Angry Customer
- Identifying Mistakes
- Call Center
- Process Improvement
- MS Excel
- Charting
- Data Labels
- Pie Chart
- Formulas and Functions
- INDEX MATCH
- Two-Dimensional Lookup
- Advanced Filter Tool
- Data Filtering
- Data Management
- Cell References
- Bar Chart
- Chart Axes
- 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
- Argument from Fallacy
- Affirming the Consequent
- Double Counting
- Circular Reasoning
- Illicit Major
- Work Rate
- Conjunction Fallacy
- Arithmetic Mean
- Rotating Elements
- Venn Diagram
- Match Type
- VLOOKUP
- Most Effective Summary
- True Statement
- Existential Fallacy
- Modal Fallacy
- Proofreading
- Return Request
- Newspaper Excerpts
- Visual Attention
- Working with Time
- Spot the Difference
- Dependent Events
- Probability
- Competing Schedules
- Exclusion Criteria
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