Contact usLogin
Core Corporate Functions>Sales>Microsoft Excel - Intermediate Level Test

Online MS Excel Assessment for evaluating intermediate proficiency in MS Excel

The MS Excel Test by Mercer | Mettl is designed to help evaluate candidates' intermediate-level proficiency in MS Excel. The assessment covers a range of subskills, including skills in using MS Excel functions, formulae, macros, VBA, formatting, tables, and tools. Using the test, managers and recruiters can gain an objective and accurate overview of employees' and candidates' MS Excel skills for hiring.

Trusted By:

Inside this MS Excel Assessment

An online MS Excel Test is a valuable tool for recruiting talent, evaluating organizational skills gaps, and planning employee development programs. An MS Excel Assessment tests an individual’s domain knowledge and can be used by talent acquisition experts to evaluate candidates on their intermediate proficiency in MS Excel. As a pre-employment test for screening candidates, this assessment helps streamline recruitment.  

The MS Excel Assessment by Mercer | Mettl has been developed by subject matter experts and provides recruiters with a comprehensive overview of candidates' expertise across crucial skill domains within the MS Excel ecosystem. The test effectively gauges the proficiency of candidates in Excel by presenting them with a range of questions focusing on various subskills. For instance, candidates' knowledge of using pivotal Excel functions to perform complex data manipulations or calculations is tested under the ‘formulas and functions’ section of the MS Excel Test for pre-employment screening. This section covers understanding functions like VLOOKUP, HLOOKUP, XLOOKUP, import, etc. The test also includes a ‘macros and VBA’ section, wherein the candidates are evaluated on their understanding of macros and visual basics for streamlining repetitive tasks, whereas the ‘formatting’ section focuses on the candidates' skills in compellingly presenting data while conveying essential insights effectively. The ‘tables and tools’ section of Mercer | Mettl’s MS Excel Assessment focuses on the ability of the candidates to interpret data through visual representations, like graphs, charts, and tables, and derive valuable insights from complex datasets. Overall, Mercer | Mettl’s online MS Excel Test for employment can help recruiters get a well-rounded understanding of the knowledge and proficiency of candidates in MS Excel to make well-informed hiring decisions.


Microsoft Excel is a powerful tool among the top computer tools used widely across all modern organizations. Microsoft Excel is a tool integrated into various business processes, not limited to departments. It is used worldwide for data analysis, performance reporting, financial management, and human resources management. That is why it has become essential for recruiters to find skilled candidates with the required expertise in Microsoft Excel and an application-oriented mindset to use the software tool to its best potential. This is how the need arose for a proper, objective way to assess candidates' skills in using MS Excel. Using a scientifically validated MS Excel Test for pre-employment screening is one of the best ways to identify and hire top talent for open positions in an organization.  

The pre-employment MS Excel Assessment by Mercer | Mettl has been designed to help recruiters ascertain candidates' proficiency in MS Excel in an objective and unbiased manner. The test evaluates candidates' intermediate ability to use the features of MS Excel, like its shortcuts, formulae, functions, pivot tables, charts and graphs, statistical operations, macros, and advanced functions. The test can assess candidates comprehensively and effectively identify talent with the highest skills and calibre.

Online Excel Test competency framework

Get a detailed look inside the test

Intermediate Excel Test competencies under scanner

MS Excel Test


Formulas and functions

This section of the MS Excel Assessment by Mercer | Mettl is designed to evaluate essential skills in using MS Excel formulae and functions. It covers candidates' understanding of formulas like VLOOKUP, HLOOKUP, import, etc.

Macros and VBA

This section of the MS Excel Test by Mercer | Mettl evaluates candidates' understanding and ability to use macros and Excel VBA to automate and customize repetitive tasks.


Under this section, candidates must demonstrate their proficiency in formatting using MS Excel. The area covers a range of subskills, such as entering data, editing data, formatting, conditional formatting, worksheet management, etc.

Tables and tools

This section of the MS Excel Assessment includes questions that can help recruiters understand candidates' skills in data manipulation, visualization, and other data-related tasks using tables and tools. The section covers a range of Excel skills, including tables, pivot tables, data tools, graphs, and charts.

Customize this Online Excel Test

Flexible customization options to suit your needs

Set difficulty level of test

Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.

Combine multiple skills into one test

Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.

Add your own questions to the test

Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.

Request a tailor-made test

Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.

The Mercer | Mettl Online Excel Test advantage

The Mercer | Mettl Edge
  • Industry Leading 24/7 Support
  • State of the art examination platform
  • Inbuilt Cutting Edge AI-Driven Proctoring
  • Simulators designed by developers
  • Tests Tailored to Your business needs
  • Support for 20+ Languages in 80+ Countries Globally

Online Excel Test can be setup in four steps

Step 1: Add test

Add this test your tests

Step 2: Share link

Share test link from your tests

Step 3: Test View

Candidate take the test

Step 4: Insightful Report

You get their tests report

Our Customers Vouch for Our Quality and Service

Frequently Asked Questions (FAQs)

The MS Excel Intermediate Test by Mercer | Mettl is an assessment designed to measure the depth and breadth of candidates' knowledge and skills in using Excel features beyond the primary level. This includes MS Excel functions, formulas, charts, pivot tables, and other intermediate-level skills.  

Yes. One can ask for the benchmark scores for this assessment. The benchmark scores can also be customized according to specific requirements. Please contact Mercer | Mettl for assistance. 

Yes. The report of the test can be customized in selective cases. Please contact Mercer | Mettl for assistance, and we will gladly devise a solution. 

Trusted by More Than 6000 Clients Worldwide





2024 Mercer LLC, All Rights Reserved

Terms of Services

Privacy Notice


GDPR Ready