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

Microsoft Excel Test for assessing intermediate Excel skills effectively

The Microsoft Excel assessment is expertly designed to assess a candidate's intermediate-level Excel proficiency, comprising diverse skill sets such as Excel formulas and functions, macros and VBA, formatting, tables, and tools. This test guarantees an unbiased and precise evaluation of applicants' Excel skills. 

Trusted By:

Inside this Online Excel Test

The Excel Online Test is a carefully designed assessment aimed at helping talent acquisition experts evaluate applicants' intermediate-level Excel proficiency efficiently. It offers an overview of expertise in various essential skill areas within the Excel ecosystem. 

This assessment effectively measures Excel proficiency by presenting a range of questions that assess key skill sections. For example, the 'Formulas and Functions' section evaluates candidates' knowledge of essential functions for complex calculations and data manipulation, such as formulas, VLOOKUP, HLOOKUP, and imports. 

The evaluation also delves into the 'Macros and VBA' section, where candidates' grasp of macros and Visual Basic is tested for streamlining repetitive tasks. The 'Formatting' section focuses on candidates' ability to present compelling data to convey insights effectively. 

Lastly, the 'Tables and Tools' section underscores the importance of interpreting data through tables, charts, and graphs, requiring candidates to demonstrate their skills in deriving valuable insights from complex datasets. 

Briefly, the Excel Test comprehensively evaluates a candidate's knowledge and proficiency in the Excel domain. It enables recruiting managers to make unbiased hiring decisions that align with their organizational needs. 

Total Questions: 30 

Time Allotted: 30 minutes 

This test is beneficial for assessing candidates for roles including: 

Senior Executive or Administrative Assistants 

Office Managers or Human Resource Assistants 

Sales, Marketing, and Operations Executives 


Microsoft Excel is a fundamental tool in today's business landscape. Its pervasive use across diverse industries for tasks like data analysis, financial management, performance reporting, and human resources management underscores the demand for proficient Excel users who approach it with an application-oriented mindset. Mercer | Mettl's Online Excel Test offers an invaluable solution to this need, serving as a pre-employment assessment tool that allows hiring managers and recruiters to gauge candidates' proficiency in MS Excel during the screening process. 

The Excel Test efficiently evaluates candidates' intermediate Excel skills, covering shortcut utilization, functions, formulae, chart creation, pivot tables, statistical operations, and macros. Its thoughtfully structured question set, featuring various difficulty levels, ensures a precise, unbiased assessment of Excel competencies. 

For hiring managers and recruiters, the Excel Test delivers several advantages, including: 

Talent Selection: This test identifies top-tier candidates with exceptional Excel proficiency. 

Fair Evaluation: The test, administered in a secure, proctored environment, ensures an honest and reliable evaluation process using features like webcam proctoring and system access controls. 

Streamlined Screening: Identifying competent candidates for subsequent recruitment stages becomes swift and efficient with the insights gleaned from the assessment. 

Comprehensive Insights: Detailed test result reports offer a well-rounded understanding of candidates' performance, empowering objective and well-informed hiring decisions. 

Online Excel Test Competency Framework

Get a detailed look inside the test

Intermediate Excel Test Competencies Under Scanner

Intermediate Excel Test


Formulas and functions

This section includes questions based on fundamental Excel skills, including formulas, VLOOKUP, HLOOKUP, functions, and importing data.

Macros and VBA

This section focuses on questions based on automation and customization using macros and Excel VBA.


This section helps assess candidates' formatting skills, including data entry, editing, formatting, conditional formatting, and worksheet management.

Tables and tools

This section helps assess test takers' proficiency in manipulating and visualizing data using tables and tools. It covers skills related to tables and pivot tables, data tools, and creating 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 4 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 Mercer | Mettl's Excel Test evaluates a candidate's proficiency in using Excel beyond the basic level. It covers various intermediate-level skills, including functions, formulas, charts, pivot tables, etc. 

Mercer | Mettl's Intermediate Excel Test is a helpful tool that efficiently assesses candidates' proficiency in using Excel features beyond the basic level, ensuring recruiters select individuals with the skills necessary for various business operations. This test provides objective and standardized evaluation that helps identify candidates with strong Excel skills. 

Trusted by more than 6000 clients worldwide

Knowledge Hub
Call us

Invited for Test?

Take test


2024 Mercer LLC, All Rights Reserved

Terms of Services

Privacy Notice


GDPR Ready