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?
The charts below show the number of cars John sold last year and the profit per car he made.
How much did John earn last year?
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:
As a customer success specialist, you can only approve in-app purchase refund requests that are made within time limits determined by whether the customer is an adult or a child and whether the request came through the app store or by email.
Adult Time Limit for Approval | Child Time Limit for Approval | |
---|---|---|
App Store Refund Request | 4 hours after purchase | 8 hours after purchase |
Email Refund Request | 8 hours after purchase | 16 hours after purchase |
NOTE: US customers use the date format MONTH/DAY/YEAR while Europeans use DAY/MONTH/YEAR. According to your company, a child is anyone born after 1/2/2010 for US customers and after the same date of 2/1/2010 for Europeans.
The table below gives the details you need to decide which customers' refund requests to approve.
Name | Purchase Location |
Birthdate | Request Source |
Purchase Date |
Purchase Time |
Refund Request Date |
Refund Request Time |
---|---|---|---|---|---|---|---|
Damian Brook | US | 1/2/2010 | app store | 1/2/2021 | 06:00 | 1/2/2021 | 09:00 |
Isla-Mae Dunn | Europe | 12/2/2010 | 2/1/2021 | 06:30 | 1/2/2021 | 23:00 | |
Tamzin Olson | Europe | 1/2/2010 | app store | 2/2/2021 | 13:00 | 2/2/2021 | 20:00 |
Erik Shepard | US | 1/11/2001 | 2/1/2021 | 13:00 | 2/2/2021 | 16:00 | |
Yassin Clements | US | 2/1/2010 | app store | 2/1/2021 | 22:00 | 2/2/2021 | 5:00 |
Jodi Fuentes | Europe | 1/1/2010 | 1/1/2021 | 11:00 | 11/1/2021 | 11:00 |
Whose refund request should be approved?
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 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?
You have been assigned the following list of tasks, and your boss needs you to complete as many as you can in the next two weeks (10 work days) before you go on vacation.
Task | Estimated Time to Complete |
---|---|
Compile Customer List | 3 days |
Write Newsletter Draft | 2 days |
Set Up Software | 1 day |
Develop Image Requirements | 2 days |
Design Landing Page | 5 days |
Embed Tracking | 1 day |
Outline Performance Report | 1 day |
Analyze Competitors | 4 days |
Which tasks will you complete before going on vacation?
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, Food Additive, Traffic Tickets, Business Reports, Text to Code, Critical Client, Service Failure, Cooking Oil, Project Hours, Work to Finish, Company Rules, Refund Demand, Cancelled Customer, Avoiding Calls, Regional Sales, Aussie Freight, Currency Conversion, Industry Sectors, Five Year Sales, Too Many Tasks, Constant Change, Vacation Requests, Middle Ages Warlords, Football Stadium Renovation, Vacation Days, Conference Instructions, Training Session, Billable Hours, Break, Large Orders, Overdue Invoices, Order Display, Daily Tasks, Thief, Alarm System, Condominium, Working Week, Game Rules, Fossil Dig, Bikers, Elves, Mold, Laptop Setup, Gas Price, Gas Price Change, Busy Intersection, Fruit Juice Processing, 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, License Match, Hair Products, Whitepaper Estimate, Busy Schedule, Hot Beverage Filters, Clock Hands, Closed Deals, Currency Exchange, Ears, Marbles, Outdoor Tub, Pages, Profit Margin, Profits, Race Track, Revenue Growth, Revenue No Growth, Snack, Spin the Wheel, Traffic Counter, Turtles, 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
- 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
- Cell References
- Bar Chart
- Chart Axes
- Data Management
- 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
- Conditional Formulas
- Data Sorting
- Date Functions
- Data Filtering
- Argument from Fallacy
- Affirming the Consequent
- Double Counting
- Circular Reasoning
- Illicit Major
- Work Rate
- Percentages
- Conjunction Fallacy
- 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
- Project Timeline
- Advanced Filter Tool
- Arithmetic Mean
- Chart Lookup
- Fractions
- Rotating Elements
- 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