Check our public questions below
Solve questions to get feedback or
take a practice test and get a free certificate.
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.
When writing an argumentative essay, it's very important to establish credibility with the audience. Providing inaccurate or false information is a surefire way to lose credibility with the reader. Once the essay’s credibility is lost, the reader will be less likely to believe other statements even if they are backed up by facts.
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:
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 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|
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?
Your company’s accounting department has asked you to give them a list of orders filtered by two periods of time:
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|
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:
Consider the following table of tire test scores:
If a tire scores 4 or less in any category, it fails the test.
What is the highest average score of the tires that pass 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.
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:
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.
|Password #||Passwords||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.
Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.
Revenue No Growth, Tax, Uber, Drawing the Next Card, Revenue Growth, Life Expectancy, Business Reports, Broken Clock, Parrots, Gas Price, Swimming Pool, Employees to Digits, Traffic Counter, Pages, Ears, Profits, Gas Price Change, Digits to Employees, Fruit Juice Processing, Penny Flipping, World Championship, Elementary School, Kindergarten, Alarm System, Game Rules, Bikers, Riviera Hotels, Masked Burglar, Math Courses, Middle Ages Warlords, Profit Margin, Race Track, Road Trip, Thief, Digital Ads, Holidays, Money, Workplace, All-Stars, Customer Parking, Working Week, Fossil Dig, Vacation Days, Lucky Roller, Elves, Product Defect, Angry Jones, Service Failure, Critical Client, Traffic Tickets, Blue-collar Workers, Renewable Energy, Refund Demand, Flower Exports, Too Many Tasks, Event Booking, Restaurant Meeting, Busy Intersection, Report Distribution, Conference Instructions, Training Session, Billable Hours, Pages Turned, Condominium, Football Stadium Renovation, Candidate Answers, Money, Currency Conversion, Order Display, Aussie Freight, Product Lookup, Large Orders, Hot Beverage Filters, Mold, Intern Design, Cancelled Customer, Eco Refrigerator, Avoiding Calls, File Encryption, Red Black Chart, Clock Hands, Gear Wheels, Olive Oil Press, Clock Angles, Brainstorming Session, License Match, Seating Plan, Expense Management, Region Code, Industry Sectors, Text to Code, Eye Color, Cooking Oil, Discount, Break, Free Calls, Plans, Document Organization, Sales Flights, Email Dictation, Sunscreen Ingredients, Hair Products, Food Additive, Work to Finish, Company Rules, Reversed Accounts, Automatic Entries, Inventory Count, Project Hours, Daily Tasks, Vacation Requests, Holiday Brochures, Whitepaper Estimate, Busy Schedule, Assign Staff, Regional Sales, Overdue Invoices, Five Year Sales.
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.