UK - 0203 693 2201 INT - +44 203 693 2201

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

Recommended Applications

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.

Complementary Tests

As well as our Microsoft Excel Test, there are several complementary tests that come under the Microsoft Office Tests module:

Difficulty Levels Available:

Basic test level - level 1

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.

Intermediate test level - level 2

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.

Expert test level - level 3

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.

WHAT NEXT?

Find out more about Excel test pricing,
benefits &
 a demo for your company

Downloads:

Microsoft Excel Test FACTFILE

[Download]

Skills Measured:
  • Computer Literacy
  • Level of Competence
  • Accuracy
  • Adaptability
  • Speed
  • Proficiency

Test Detail:
  • 15 questions asked
  • 20 minutes to complete
  • 15 minutes average taken
  • Practice available
  • Randomised question delivery
  • Tailor testing “level”
    (basic, intermediate, expert)

Complementary tests

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.

Microsoft Excel Test sample question
sample report- Microsoft Excel 2013 Basic Test

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.

Our Customers Include
What Clients Say About Us
Skillarena have given us a fresh perspective on our workforce and the motivation to build upon attracting the right people through an engaging employer brand.
Alison Tookey Employee Relations Advisor, Home Retail Group
Choosing Skillsarena was the best business decision we made, the system is slick and easy to use, our business processes are faster and I recommend the company when speaking to other about their recruitment problems.
Alan Blake Managing Director, Secom Plc
Skillsarena’s tests have been used throughout the organisation for all levels of recruitment up to the most senior and have been very well received. The response to the tests has been overwhelmingly positive. All of our recruitment managers are absolutely delighted.
Mark Gillmam Recruitment Business Partner, Southern Housing