Contact usLogin
Contact usLogin
All Tests >Microsoft Excel Skills Knowledge Test

Microsoft Excel Skills Knowledge Test to assess intermediate Excel proficiency effectively

The Microsoft Excel Skills Knowledge Test measures a candidate's intermediate-level Excel proficiency. It includes skill sections, Excel formulas and functions, formatting, tables and tools, macros, and VBA. The test provides an objective and accurate evaluation of Excel skills.

Trusted By:

Inside this assessment

The Microsoft Excel Online Test is a domain knowledge test designed to help recruiters evaluate the applicants' intermediate Excel proficiency. The assessment provides an overview of the expertise across various critical skill domains within Excel.   

The test evaluates Excel proficiency by presenting various questions to measure the critical skill sections. For example, the ‘formulas and functions’ section measures test takers' skills and knowledge of crucial functions necessary for performing complex calculations and data manipulations like formulas, import, VLOOKUP, HLOOKUP, etc. The assessment focuses on the ‘macros and VBA’ section, wherein examinees' knowledge and understanding of macros and visual basics to streamline repetitive tasks is measured. The ‘formatting’ section focuses on the respondents' skills in presenting data compellingly to convey insights effectively.  

Lastly, the ‘tables and tools’ section underscores the significance of interpreting data through tables, charts, and graphs, necessitating that candidate highlights their skills to derive valuable insights from complex datasets. Therefore, the Online Excel Test offers a well-rounded evaluation of a candidate's knowledge and proficiency within the Excel domain. It enables recruiting managers to make unbiased, informed hiring decisions that suit their organizational needs.


Microsoft Excel is a powerful tool ingrained in business processes worldwide— whether for financial management, data analysis, human resources management or performance reporting. There is a need to find skilled candidates with expertise in this software and an application-oriented mindset. That is where Mercer | Mettl’s Microsoft Excel Skills Knowledge Test comes into the picture. It is a pre-employment test that hiring managers can utilize during the screening process to ascertain candidates' skills in MS Excel. 

This test evaluates the intermediate proficiency of applicants in using Excel features. This comprehensive test comprises questions of different difficulty levels, ensuring an accurate and objective assessment of Excel skills.

Recruiters stand to gain substantial advantages from the Excel Proficiency Test, some of them being mentioned below: 

  • Top talent selection: By employing this test, talent acquisition experts can identify applicants of the highest skill caliber in Excel proficiency.  
  • Fairness in assessment: The test is administered in a secure, proctored environment through essential features such as webcam proctoring, limited system access, window violation checks, etc.  
  • Effective screening: Finding competent candidates for subsequent recruitment stages becomes streamlined and efficient with assessment insights.  
  • Comprehensive insights: Test result reports offer a thorough understanding of assessment takers' performance, facilitating objective and informed hiring decisions.  

The test gauges domain expertise in the following skills:  

  • Function and formula utilization: Ability to use functions and formulas for data analysis.  
  • Pivot table expertise: Competence in extracting actionable insights from raw data using pivot tables.  
  • Statistical analysis: Capability to perform statistical analysis to support informed decision-making.  
  • Graphs and charts mastery: Ability to represent data visually using graphs and charts.  
  • Macros and advanced functions: Proficiency in automating spreadsheets and leveraging advanced Excel functions.  

Online Excel Test competency framework

Get a detailed look inside the test

Microsoft Excel Skills Knowledge Test Competencies Under Scanner

Intermediate Excel Test competencies


Formulas and functions

This section includes skills related to formulas and functions in Excel, like formulas, VLOOKUP, HLOOKUP, functions, and import.

Macros and VBA

This section includes automation and customization with Excel VBA and macros.


This section measures the candidates' formatting proficiency to assess skills like editing, entering, and formatting data, worksheet management, formatting and conditional formatting.

Tables and tools

This section covers test takers' data manipulation and visualization knowledge with tables and tools. The skills include tables and pivot tables, data tools, graphs, and charts.

Customize This Microsoft Excel Skills Knowledge 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 Microsoft Excel Skills Knowledge 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

Microsoft Excel Skills Knowledge 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 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, please contact Mercer | Mettl for assistance.

Yes, this is possible. Please contact Mercer | Mettl for assistance.

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