Pre-Employment Microsoft Excel Tests

(Basic & Intermediate)

Find out whether your candidates have the Excel skills they need for the job.

Try It Free Get a Demo

The accurate recording, manipulation, and analysis of data is of vital importance to any business. From bookkeeping to industry research, spreadsheet software has become the tool of choice to organize data, and the most widely used program is Microsoft Excel. Employers must ensure that the employees who regularly work in spreadsheets are competent and quick Excel users, and hiring managers who are looking to fill such positions should strongly consider a standard Excel test for interviewing purposes.

What is a pre-employment Excel skills test?

A pre-employment Microsoft Excel test is an assessment given to job candidates to determine their current grasp of the spreadsheet software Microsoft Excel. When used during the hiring process, this test can help you narrow down your pool of candidates by weeding out those applicants who don’t have the software knowledge you need.

The benefits of testing your job applicants

By requiring an Excel skills test, you can ensure that everyone you bring in has the spreadsheet knowledge needed for a particular role at your company. You can also create custom aptitude and skills tests that include questions tailored to the job you’re hiring for.

Occupational roles that might benefit from an Excel test for a job interview include:

  • Accountants
  • Bookkeepers
  • Financial analysts
  • Administrative assistants
  • Information clerks
  • Sales managers
  • Manufacturing engineers
  • Human resources associates
  • Technical writers
  • Software QA testers
  • Childcare workers
  • And more

We offer 2 Excel skills tests: Basic & Intermediate

basic-excel-skills-test

What does the Hire Success® pre-employment basic Excel test include?

Topics covered in the Basic Microsoft Excel Proficiency Test include:

  • Setting up, using, and understanding formulas
  • Basic use of shortcuts and keystrokes
  • Absolute and relative references
  • Layout and printing options
  • Expected cell values
  • Operators within functions
Number of questions

25

Test type

Skills test

Time limit

30 minutes

intermediate-excel-skills-test

What does the Hire Success® pre-employment intermediate Excel test include?

Topics covered in the Intermediate Microsoft Excel Proficiency Test include:

  • Intermediate use of shortcuts and keystrokes
  • Pivot tables
  • VLOOKUP
  • References (circular, absolute, relative)
  • Expected cell values
  • Operators within functions
Number of questions

28

Test type

Skills test

Time limit

30 minutes

You will receive up to 3 separate reports:

Math Skills Summary Report-1

Microsoft Excel Skills Summary Report

The Hire Success® Summary Report for every Excel skills text is broken down into sections.  

  • High-level summary. Get information specific to the test taker, such as overall score, weighted score, number of questions correct, and time to complete.
  • Summary of statistics by cohort. Incorporating campaign, position, location, and account, this section shows you how the applicant compares to other cohorts.
  • Distribution of people. A graph shows you the distribution of people within the applicant’s campaign.
  • Scores by category. Examine summary scores by category.
Math Skills Detail Report-1

Microsoft Excel Skills Detail Report

The Detail Report for the Excel skills test shows you how the test taker answered each question:

  • Section 1 — incorrectly answered questions
  • Section 2 — correctly answered questions

Grouping the candidate's test answers in this way not only provides you with an easy way to gauge where the candidate made mistakes but also helps you get an idea of the candidate’s areas of strength or weakness. You may want to follow up on some concepts in an interview if the candidate is selected for the next step in the hiring process.

Candidate Audit Report-1

Candidate Audit Report

If you activate the cheating mitigation feature for your Excel skills test, you’ll receive the Hire Success® Audit Report showing you a timeline that reveals:

  1. When the test taker selects answers within a question.
  2. When the test taker moves to the next question.
  3. If or when the test taker leaves/returns to the test.

The report also shows whether the test was automatically submitted because the candidate left the testing window for too long (possibly to look up an answer) or ran out of time.

This feature doesn’t just help you find out whether applicants know the test answers — it uncovers how well they know them. With the Audit Report, you’ll have added confidence in your hiring decisions.

Frequently Asked Questions

How will I receive each job candidate’s test results?

Each time an Excel skills test is submitted, you’ll receive two reports (or three, if you activate cheating mitigation). An email notification will be sent to you immediately upon submission, and results will be available for review in your Hire Success® online account instantly. You can view results in your account securely from any internet-connected device, and print or share results if needed.

Can I customize the pre-employment Excel tests?

Yes! With our Custom Test Builder, you can use questions from our pre-designed Excel test in combination with any questions you want to add, creating an exam that’s specific to the job you’re hiring for. You can also include questions in other areas, such as Microsoft Word, accounting, or finance.

Learn about the Hire Success® Custom Test Builder

How much does the Excel skills test cost?

Hire Success® offers a complete online system that helps you improve your recruiting, interviewing, and hiring process. Our pricing model is based on factors specific to your company, industry, and team size, so the best way to get accurate pricing information is to contact us for a tailored quote.

Request a customized quote from Hire Success®

Ready to take your hiring to the next level?

Take a free test run of our whole system — from the Microsoft Excel test to the personality profile to the integrity test and more — and find out why thousands of companies have turned to Hire Success to build stronger, more organized, and more consistent hiring systems.

Try It Free Get a Demo