Administrative Assistant 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
An author writes an argumentative essay to persuade readers to agree with a claim about a topic. When writing an argumentative essay, it's important to establish credibility with readers to convince them that the author is trustworthy. True statements, accurate evidence, and clear logic increase an author's credibility. However, false statements, inaccurate evidence, and unclear logic make an author less credible. With lower credibility, an author is less likely to persuade readers to agree with a claim--even when it is trustworthy.
Select the statement that most effectively summarizes the above text:
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?
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 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.
|Other (Meetings, etc.)||4|
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.
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.
|_____||Name||Bhuvana Ananathram||Bhuvana Anantharam|
|_____||Order Total||USD 1,717,771.17||USD 1,717,771.17|
|_____||Address||1255 34th, 32356||1255 34th, 323S6|
|_____||Payment||ALL 1,717,771.17||ALL 1,717,771.77|
A client requests a phone call with you at 1:30pm tomorrow their time. The client’s time zone is six hours behind your time zone.
What time would you use to add the phone call to your schedule? __________
You are covering for a coworker who is out on leave. Your coworker has left you a voicemail message specifying the tasks you will need to do for them.
Hi there! Thanks so much for covering for me. So, the main thing you need to do is complete the monthly revenues spreadsheet. You can do that by looking up the latest ad revenue in the reporting from marketing. Ok, so after you do all of that, go ahead and check my email and then my voicemail to see if there are any requests from the executives. If there are any such requests, do those first unless you have an emergency request from another department. Once you’re done with fulfilling requests, please water my desk plant after you turn off the computer. Oh, wait, I should have mentioned a couple of things: you have to log in with manager access in order to see the marketing reports, and you'll need to send me an update email right after you finish handling the requests. OK, thanks again. This is a big help! I owe you lunch when I’m back.
Place the tasks in the correct order.
Carefully read the following excerpt from an article on paper production:
With the recovery rate of used paper for recycling approaching 70 percent in the United States and Europe, and approaching 80 percent in Japan, to keep up with our demand for paper we need to continue using fresh fiber as well as recycled, according to the premise set forward in a new report by the World Business Council for Sustainable Development (WBCSD).
Detailing the reasons why fresh fiber combined with recycled is important for a single integrated wood fiber system, the report examines the “complementarity” of using both and discusses the functions of different types of fibers and the issues related to both recycling old fiber and sourcing fresh fiber. In 2012, 400 million tons of paper and paperboard were produced and consumed globally, which is double that in 1985, notes the report. As the population continues to expand and standards of living increase, this number is expected to climb by another 40 percent by 2028. While many would advocate for cutting down on paper use in the first place, in the face of global demand the most sustainable fiber may have to be the next best thing. But therein lies the rub: finding adequate quantities of said fiber will be the challenge of the global pulp and paper industry.
Which statement most effectively summarizes the text?
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:
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|
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?
As part of your customer service work for QuikPizza, you monitor the restaurant's social media accounts to make sure that customers have positive experiences with the restaurant. When you come into work one morning, you see the following public post from the night before, which already has 138 likes.
Given that this message is on social media, how do you respond appropriately?
John has some apples, and two brothers, Jack and Jim.
John eats 3 of his apples and splits the remainder equally between himself and each one of his brothers. Jack and Jim both eat half the apples they have been given. Together the three brothers have 4 apples left.
How many apples did John start with?
Germany's economy avoided falling into recession during the final three months of last year. This means that it avoided two consecutive quarters of negative GDP growth, which is the definition of a recession. This was a small, but positive, surprise for all analysts who, after the July-to-September period that featured a 0.3% decline, predicted the continuation of this negative trend.
Reasons for slower growth last year include a slowdown in the global economy and a weaker car sector, with some German consumers less willing to buy new cars amid confusion over new emission standards.
Joe Johnson, senior financial analyst, told the BBC that US tariffs on EU car exports, which US President Donald Trump has threatened, could have a major impact on Germany. He thinks that, if this happens, Germany might fall into recession.
What can be concluded from the text above?
Which product line saw the largest absolute increase in income (dollar amount, not percentage) in the second half of the year compared to the first half of the year?
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?
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.
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 been asked to create a column chart and need to make it look the same as the chart provided in the image below.
Your task is to download the ‘SalesComparison-RawData.xlsx’ file and use your spreadsheet knowledge to create the chart shown here. You should attempt to recreate this chart using any columns colors you want, but be sure to:
- Create a clustered column chart.
- Set up the horizontal axis categories and remove horizontal gridlines to match the image.
- Adjust the vertical axis scale and remove vertical gridlines to match the image.
- Add a chart title, vertical axis title, and legend that match those displayed in the image above.
- Ensure your data series are in the correct order.
When you have completed the chart, save it in .xlsx format, then upload that file for evaluation.
Cats are common pets throughout the world, and their worldwide population exceeds 500 million.
Cats are the second most popular pet in the U.S. by number of pets owned, behind freshwater fish. Although cat ownership has commonly been associated with women, research has shown that men and women in the U.S. are equally likely to own a cat.
They are ranked as the third most popular pet in the U.K. by number of pets owned, after fish and dogs, with 8 million being owned.
What can be concluded from the text above?
A customer phones to complain about a printer she purchased last week that stopped working. The customer tells you the brand of printer and it's clear she has called the wrong number because your company has never sold that brand.
What responses show appropriate customer service in this situation?
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.
Which of the passwords are the same as the mirrored images?
To improve communications, your company's CEO gives you a list of meetings she wants you to schedule between all possible combinations of herself, the CFO, the COO, and the CCO. You come up with your own list to compare with hers.
Based on your list, which meetings are missing, mistaken, or misspelled on the CEO's list?
It takes Billy 4 hours to paint a fence by himself. It takes Suzy 6 hours to paint the same fence by herself.
How long will it take them if they start working on the same fence together and neither of them stops until the fence is completely painted?
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.
|Damian Brook||US||1/2/2010||app store||1/2/2021||06:00||1/2/2021||09:00|
|Tamzin Olson||Europe||1/2/2010||app store||2/2/2021||13:00||2/2/2021||20:00|
|Yassin Clements||US||2/1/2010||app store||2/1/2021||22:00||2/2/2021||5:00|
Whose refund request should be approved?
Your company just introduced a new pricing policy. In order to further motivate customers to buy your products, your company will give discounts on each order based on the total price of the order.
Your boss needs you to use the data in the Discounts worksheet to build a formula that calculates the applicable discount percentage according to each order’s total amount. You’ll add that formula to column D and then write a formula for column E that calculates the final order amount including the discount.
Note: Do not use any array formulas in your work.
Your task is to download the file ‘OrderDiscounts-RawData.xlsx’ file and execute all parts of this request. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.
Your company sells tea and coffee to a variety of customers through its sales representatives. The sales manager is preparing for the annual performance reviews in which he reviews the achievements of all the sales representatives as a basis for discussing bonus compensation and raises.
He asks you to prepare some pivot tables to help him prepare for these reviews:
For Pivot Table 1, you’ll show Total Sales by Employee and Category.
For Pivot Table 2, you’ll show Total Sales by Years, Quarters, and Months per each Employee.
Ensure that both pivot tables match the layout shown below.
Your task is to download the ‘PerformanceReviews-RawData.xlsx’ file and execute all parts of this request. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.
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.
117 more premium Administrative Assistant questions
Revenue No Growth, Tax, Uber, Drawing the Next Card, Life Expectancy, Business Reports, Parrots, Swimming Pool, Employees to Digits, Traffic Counter, Pages, Ears, Digits to Employees, Fruit Juice Processing, Penny Flipping, World Championship, Elementary School, Kindergarten, Game Rules, Bikers, Math Courses, Middle Ages Warlords, Profit Margin, Race Track, Customer Parking, Working Week, Fossil Dig, Vacation Days, Lucky Roller, Elves, Product Defect, Angry Jones, Service Failure, Critical Client, Blue-collar Workers, Renewable Energy, Refund Demand, Flower Exports, Pages Turned, Condominium, Currency Conversion, Order Display, Product Lookup, Mold, 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, All-Stars, Alarm System, Road Trip, Traffic Tickets, Candidate Answers, Masked Burglar, Workplace, Thief, Busy Intersection, 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.
Skills and topics tested
- Numerical Reasoning
- Chart Lookup
- Verbal Reasoning
- Most Effective Summary
- Newspaper Excerpts
- Logical Reasoning
- Non-Independent Events
- Inductive Reasoning
- Attribute Substitution
- Linear Equations
- Divide and Conquer
- Double Counting
- Gambler's Fallacy
- Affirming a Disjunct
- Deductive Reasoning
- Fallacy of Division
- Set Theory
- Circular Reasoning
- Fallacy of the Undistributed Middle
- Fallacy of Exclusive Premises
- Critical Thinking
- Existential Fallacy
- Modal Fallacy
- Illicit Major
- Understanding Rules
- Interpersonal Skills
- Customer Service
- True Statement
- Fallacy of Composition
- 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
- Attention to Detail
- Verifying Data
- Bar Chart
- Table Lookup
- Alphabetical Order
- Following Instructions
- Identifying Mistakes
- Exact Match
- Affirming the Consequent
- Masked-Man Fallacy
- Argument from Fallacy
- Conjunction Fallacy
- Basic Math
- Visual Attention
- Written Communication
- Email Etiquette
- English Language
- Grammar and Punctuation
- Tone and Voice
- Clear and Concise
- Giving Instructions
- Time Management
- Reordering Tasks
- Vacation Policies
- The 4Ds
- Finding Availability
- Assigning Work
- Competing Schedules
- Project Timeline
- Pivot Tables
- Data Labels
- Pie Chart
- Conditional Formulas
- INDEX MATCH
- Two-Dimensional Lookup
- Date Functions
- Advanced Filter Tool
For job roles
- Administrative Assistant
- Executive Assistant
- Office Coordinator
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
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.
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
a test remotely
Sort candidates and
get individual reports