Why do you need a Microsoft Excel Test
Most office employees will use Microsoft Excel for one use or another, whether it be working with formulas or manipulating charts. Our MS Excel tests cover everything from Excel basics to Advanced Excel skills depending on the level chosen allowing you to evaluate their knowledge.
If you’re hiring for a position requiring Excel spreadsheet skills, then our Microsoft Excel Test is exactly what you need to ensure your job applicants have what it takes before you hire them. It’s fast, efficient and will give you confidence to make a smarter hiring decision.
Or do you want to improve your Excel training provision? Using this assessment you can identify your existing employees’ skills gaps and develop them with more advanced MS Excel skills so they can improve their day-to-day work.
Download the Microsoft Excel Test FactFile for further information
Overview of Test
Designed to test an individual’s ability to perform tasks within a simulated Microsoft Excel environment. Unlike most Microsoft Excel Tests this test does not consist of multiple choice questions, instead this simulated test platform is designed to closely mimic the look, feel and functionality of the original spreadsheet software. The functionality is fair to candidates in that it allows the tasks to be completed in a familiar way using menus, buttons, left clicks, right clicks and keyboard shortcuts in a way that they are most accustomed.
The assessment is available at a variety of levels [basic, intermediate & expert levels] enabling you to assess at a level relevant to both the candidate and the role. A comprehensive report breaks down ability by level, percentile and correct answers.
The levels were initially based on Microsoft Training and have been “levelled” in line with real world day to day activities. The levelling is based on a common consensus from Skillsarena’s view, customer feedback and the Skillsarena User Group. Levels assigned to candidates should be chosen as appropriate to the needs of the role. In the vast majority of cases Basic is appropriate and perhaps intermediate in some cases.
Available software versions: Microsoft Excel 2003 | Microsoft Excel 2007 | Microsoft Excel 2010 | Microsoft Excel 2013
For persons who need to demonstrate understanding and capability in MS spreadsheet applications prior to employment or as part of training needs analysis.
Consider that the levels are based on “typical use” of the application; for example basic would cover those tasks that are performed regularly and easily, the majority of times by most people using the application day in day out. More difficult tasks such as those in intermediate and certainly expert levels will only be performed by those that have more in-depth knowledge of the application and typically use far less basic functionality.
As well as our Microsoft Excel Test, there are several complementary tests that come under the Microsoft Office Tests module:
Difficulty Levels Available:
Required to understand the principles of Microsoft Excel & demonstrate they are able to competently navigate the software, create & save their work, & perform essential and common daily tasks. This level is appropriate for a candidate who uses MS Excel daily as a simple spreadsheet application.
Required to understand the concept of Microsoft Excel & demonstrate they are able to perform tasks which are required frequently for more advanced cell calculations & setting changes. This level is appropriate for a candidate who regularly writes templates, interactive tables, charts & formulas within spreadsheets.
Required to be highly proficient in using Microsoft Excel & demonstrate they are able to change permission settings, display an understanding of advanced macro commands, lookups, pivot tables & complex formula. This test builds on Core by increasing the rarity of the tasks tested & the depth of knowledge required to complete the task within the given time. This level is appropriate for a candidate who is expected to use MS Excel autonomously & understand a greater scope of the software’s capabilities.
Find out more about Excel test pricing,
benefits & a demo for your company
Excel Test Sample Questions
Basic. Clear the data in cell B4.
Intermediate. Give the chart on the worksheet “Charts” the title “Staff”.
Expert. In the current worksheet use the filter list option so that only “Electronics” items are displayed.
Download a sample Microsoft Excel Test Basic report
Click to download a sample Microsoft Excel 2013 Test Basic report to get a feel for the type of analysis you can receive from a candidate taking this test.
Report clearly shows the candidate’s percentage score, score by category (formatting, basic tasks, functions etc), as well as giving them a percentile score against others in your organisation and worldwide.
Require bespoke adjustments to these tests?
All assessments can be adjusted to meet your specific needs. Bespoke activities often include the addition of organisation specific questions relating to specific software, company policies and procedures as well as the removal of questions if required.
To find out more about our bespoke assessments, click here.