Everything You Need to Know
When potential employers ask you to take a Microsoft Excel assessment test, they are trying to determine whether or not you are the best candidate for the position. This test allows you to put your best foot forward, without worrying about impressing an interviewer. With a little bit of practice and training, you can prove you have the basic, intermediate, or advanced skill set that is needed to be successful in the position.
The Excel Assessment test is objective, and shows hiring managers that you are capable of helping their company. Start by understanding what they require, so you can sharpen your Excel skills before the test.
You need to demonstrate your ability in formatting spreadsheets, writing formulas, or manipulating data with pivot tables, to show you are a better choice than lesser-skilled job applicants.
Larger companies often use a test developed by one of the industry’s leading skills assessment testers, while smaller companies frequently create their own test. This non-standardized test means candidates are best off practicing on assessment tests that offer a wide range of questions and topics. Tests are typically given in three levels, based on the job requirements.
Your assessment tests can be administered either before or after an interview as a way to screen potential employees for a position. Tests can be administered in the office either immediately before or after an interview, or from your home, using either your version of Excel or an in-app test version.
It’s important to find out which version of Excel you will be tested on, as some features are different in the earlier versions of Excel. iPrep’s practice tests will prepare you for MS Excel 2013, 2016, or 2019/Office 365.
Tests are typically administered in one of two ways:
- Excel interactive spreadsheet
- Multiple choice
In multiple choice versions of the test, you will be asked questions and directed to choose the best response. These questions will cover the areas of Excel that you are expected to know in the role and will look something like this:
Excel Interactive Spreadsheet
When faced with an interactive spreadsheet test, you will be given an actual spreadsheet and asked to complete specific tasks. For example, in the question below you are being asked to add a row into an actual Excel file.
Questions can be single-task questions, where you are asked to do one thing, or multi-tasked. In a multi-tasked question, you might be asked to do the following in the Excel pictured below:
- Add a tape measure into the new row
- Add in the following sales figures: January – $27, February -$35, March – $11
- Add in a formula to calculate the average monthly sales figures for tape measures
- Add in a formula to calculate the total sales for the first quarter
Excel is a powerful program that is capable of doing any number of things. However, the role you are applying for probably won’t require you to know everything about Excel. Your test should only ask questions that are relevant to the position you are applying to.
That being said, most Excel roles are divided into three levels:
- Excel Beginner Test – for administrative or clerical positions
- Excel Intermediate Test – roles that require calculations
- Excel Advanced Test – roles that require data analysis and working with data
The format of each test differs greatly depending on the company administering the test. Some will ask you to take the test at home, while others proctor the exam in the office.
There are three generally accepted proficiency levels in Excel. Here are the topics you can expect for each of these levels:
|This skill set is needed by people in administrative and clerical positions. Therefore, the tasks expected of employees in these roles are of a formatting nature. You can expect the following types of tasks to be tested:||This skill set is needed by people working with the information contained in the spreadsheets. These tasks require a deeper knowledge of Excel:||This skill set is used by people who need to analyze the data contained within the spreadsheet. These tasks require a strong knowledge of Excel:|
|Copy/paste||Use Autosum||Full PivotTable use|
|Add/remove column or row||Sort data through auto-filtering||Enter calculations using average functions|
|Fill cell range with series of labels||Create conditional formatting rules||Sort table using multiple fields|
|Move a chart in a worksheet||Change chart types||Add new fields to table|
|Navigate between worksheets||Create PivotTables||Use goal seek|
|Open a workbook||Filter PivotTable data||Data validation|
|Open/close Excel||Freeze top rows||Record macros|
|Apply bold or italics formatting to cells||Add comments||Apply styles to a chart|
|Change cell colors/fonts||Apply number formatting to cells||Lock cells|
|Preview and print workbooks||Merge cells|
If you are applying for a position at a large company, they may use a commercially developed standardized test. These tests typically take 15-45 minutes to complete and contain between 10-35 questions.
Results Scale and Interpretations
Companies that create and score their own tests will compare your results with that of other candidates they have interviewed, as well as requirements for the job. It’s important to do as well as possible on the Excel assessment, as it demonstrates your ability to contribute to the company immediately. Candidates with lower scores require training, which takes time and costs money, so doing well on the test will help you stand out among other job seekers.
Larger companies which use assessment tests receive a report detailing the following:
- Your score
- Your percentile
- Your score in different sections
Your potential employer could receive a report that looks like this, which shows how well you did, compared to other test takers.
The report will also break down your test performance by levels. While an overall score may not be that impressive, the employer can see if a candidate has strong basic skills, which may be enough for the role.
Additionally, the report includes scores by topics. This provides further insight to the hiring manager as to the areas where you have strong skills, and those areas which might require additional training.
This Score Report, which comes from the Kenexa Prove It Power User test, includes the raw score, percent correct, percentile ranking, and global average.
iPrep: Concise. Focused. What you need.
Excel Assessment Test FAQs
Many employers require their potential employees to take an Excel assessment test. This test lets the hiring manager know how well the candidate knows Excel, and whether or not they are capable of completing the tasks in Excel that their role would require.
Some companies use multiple choice tests, while others provide the candidate with an interactive Excel sheet and ask the job candidate to perform different tasks.
Excel tests can cover a number of topics, depending on the role. For someone looking at an administrative or clerical position, the test would challenge the candidate with basic activities, such as formatting and file management. Sales or marketing roles would require a candidate to write formulas and use pivot tables to analyze data.
While different roles have different requirements, here are the five most common topics that appear in Excel assessment tests:
• Opening and saving files
• Sorting data based on different types of criteria
• Adding and removing rows or columns
• Autofilling cells with data
• Sum/Average functions and formulas
Before taking an Excel assessment test, ask about the test format and version of Excel that you will be tested on. Once you have that information, you can work with online practice tests, like those offered by iPrep, to familiarize yourself with the types of questions that are asked on these tests. This will help you identify your strengths and weaknesses, and the tips and tricks they offer will help you improve on the areas where you did poorly.
Employers want to know that you can handle the Excel tasks that you will come across in your job. This generally means that they want someone who can easily navigate Excel’s ribbon and taskbar, format worksheets, use functions, and manipulate data.
Excel is used for a number of different functions. A Capital One 2017 report found that 82% of middle skill jobs require digital skills, including spreadsheets. However, it is an especially important tool in the following roles:
• Administrative assistants and clerical workers
• Business analysts
• Marketing and sales managers
• Loan officers
• Project managers
Job listings that mention Excel skills as a requirement are very likely to require candidates to take an Excel assessment test.
- Test Location: The Excel Assessment test is administrated by the hiring company, typically in their office.
- Test Schedule: The test generally takes place following at least an initial interview.
- Test Format: Multiple choice or computerized simulation.
- Test Materials: Computer. Additional materials determined by each employer.
- Cost: None
- Retake Policy: Determined by each employer.
While most small businesses create their own Excel assessment, larger corporations tend to use assessments from one of these leading test developers.
IBM Talent Assessments (formerly Kenexa Prove lt) – There are 3 versions of this test: Normal User, Power User, and Whole Test. The test is an interactive test, where users are presented with actual spreadsheets and challenged to complete different tasks. The test is administered online, and untimed, although the speed in which you complete tasks are measured and influence your final score. The Normal User test has 30 questions, the Power User test has 25 questions, and the Whole Test has 55 questions.
January 2020 update: IBM announced that the Kenexa Prove It Excel assessments will be gradually shifted from the IBM Talent Assessments platform to SHL, a global leader in assessment tests.
Isograd – A 25-questions assessment that takes about 30 minutes to complete. It is taken online and provides immediate skills report to the test administrator.
Indeed – This multiple choice test is available for beginning, intermediate, and advanced users.
eSkill – These tests are highly configurable by the test administer, allowing them to customize the number of questions, level of questions, and time limit.
EmployTest – This interactive Excel spreadsheet assessment asks about 35 questions covering formatting, functions, charts and formulas. Results are immediately emailed to test administer.
Interview Mocha – This ten-question assessment test takes 20 minutes to complete. Test administrators can customize the level of difficulty, as well as introduce their own questions into the test.
Disclaimer – All the information and prep materials on iPrep are genuine and were created for tutoring purposes. iPrep is not affiliated with IBM, Isograd, Indeed, eSkill EmployTest, Interview Mocha or other Excel assessment test developers.
Get a taste of the Excel Assessment Test by practicing with these sample questions:
0 of 7 questions completed
You have already completed the test before. Hence you can not start it again.
Test is loading…
You must sign in or sign up to start the test.
You must first complete the following:
0 of 7 questions answered correctly
Time has elapsed
Tips for Passing
Doing well on the Excel assessment is something potential employers consider while making a hiring decision. Here are a few tips for how you can get the best score possible:
- Understand the job requirements and level of Excel proficiency required. Prepare for these types of questions.
- Review common formulas, such as SUM, COUNT, IF, VLOOKUP, AND, CONCATENATE, and more.
- Review common keyboard shortcuts in Excel. These shortcuts save a significant amount of time over the course of a workday.
- Practice creating and filtering PivotTables. These are especially important for a role that involves analyzing data, and are very common in advanced-level Excel tests.
- Make sure you’re up to date on the version of Excel that is being used in the office. Depending on the company, you may find yourself working on Excel 2010, 2013, 2016 or 2019/Office 365.
- Take practice tests, like those offered by iPrep. These interactive tests will guide you by highlighting the skills you have and the areas you need to improve upon.
- Question 1 of 7
Which of the following formulas will not yield the correct daily average as in cell G8?CorrectIncorrect
- Question 2 of 7
Each day, $1 bills and $0.01 and $0.05 coins are given to charity.
Which function enables filling cell G15 with the correct number without using additional functions? You may assume that the rest of the table is automated upon inserting quantities (columns B and F).CorrectIncorrect
- Question 3 of 7
What is probably the reason for the error markings in column C?CorrectIncorrect
- Question 4 of 7
If the merged cell AB2 is deleted along with the entire column, how will the table be affected?CorrectIncorrect
- Question 5 of 7
The chart above was produced based on the range A1:C4. It was not intended that the chart will include the leftmost set of columns (“component”). What can be done in order to create the proper graph as seen below?CorrectIncorrect
- Question 6 of 7
I want the top rows of the table to display Field Names which are not required and call for Excel Data Format “Number.” Which of the following would not reach this goal?CorrectIncorrect
- Question 7 of 7
Which function can be inserted in cell G5 and be copied to all the cells of column G in order to calculate the overall price of the items?CorrectIncorrect