The MS 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 MS 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 MS 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.
Charts are a powerful visualization tool for summarizing and reporting data and are essential for communicating data-based information quickly and efficiently.
Vertical column charts are useful for comparing values across categories and showing trends in data sets over a period of time.
This is a new addition to our question library.
Public questions (free account) are common interview questions. They are great for practicing, or if you want to filter candidates using the classic problems.
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.
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.