The Excel test evaluates a candidate’s ability to work with spreadsheets, including the knowledge of how to organize, calculate, analyze, and visualize data contained within a spreadsheet.
It’s an ideal test for pre-employment screening of candidates applying for a variety of job roles. A good candidate for any job requiring the use of spreadsheets will be able to display competency with using functions, writing formulas, sorting and filtering data, and creating accurate charts. This Excel test can be used to screen large groups of candidates to select only those with the required Excel knowledge to bring in for an interview.
This test requires candidates to download data files, perform assignments within spreadsheet software, and upload their solution files for automatic evaluation. Candidates can use either their personal copy of Microsoft Excel or the free web version of Excel to complete the test.
TestDome is trusted by businesses large and small
We’re top rated for our tests’ quality and reasonable completion time
Spreadsheet usage is a core competency for many office-based jobs, and Microsoft Excel is by far the most popular spreadsheet software used worldwide.
Various functions allow a user to quickly and efficiently look up relevant data from a list or table.
Formulas and Functions
Formulas and Functions
The key feature of spreadsheet applications is the ability to add formulas or functions to refer to the contents of other cells when making calculations.
Public questions (free account) are common interview questions. They are great for practicing, or if you want to filter candidates using the classic problems.
This is a new addition to our question library.
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.
Our tests are designed to put candidates into either the pass group or the fail group so you can find the best candidates faster.
We have pre-built tests and questions, but you can customize them however you like. Change the pass/fail scores, time requirements, and more.
Use tests that solve real-world problems, with no answers that can be easily found online. Because we test performance and skills (not information), we allow the use of online resources, just like in real life. Copy/paste prevention and online proctoring via webcam prevent cheating.
Get an overview into the percentage of passes and fails. Then dive deeper into the results of your top candidates to select who goes onto the next phase of hiring.