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
Our sample questions are free for companies to use on a trial plan. See more about our premium questions for paid plans below.
# of candidates
Spreadsheet usage is a core competency for many office-based jobs, and Microsoft Excel is by far the most popular spreadsheet software used worldwide.
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 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.
Your task is to download the file ‘Tax Inclusive-Raw Data.xlsx’ file and write formulas to calculate the retail prices, inclusive of sales tax, using the net prices of each product. Make sure you reference cells A5 and B5 in your formulas. 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.