Contact usLogin
  • /header/Online-Hackathons.svg
    Online Hackathons

    Innovate, ideate and engage

Core Corporate Functions>Sales>Microsoft Excel - Intermediate Level

Online Excel Test to assess candidates with intermediate Excel proficiency

Online excel test is designed to assess the intermediate Excel skills of a potential candidate. Online Excel assessment helps you test those candidates who are proficient in Excel at the intermediate level.

Trusted By :

Inside This Assessment

Microsoft Excel is a powerful tool used extensively in most modern businesses. It is evident that the Excel tool is ingrained in business processes worldwide— whether for business analysis, performance reporting, managing human resources, or operations management. There is, therefore, a need to find skilled candidates with expertise in this software and an application-oriented mindset. That is where Mercer | Mettl’s online Excel test comes in handy. It is a pre-employment assessment that hiring managers and recruiters can use during the job screening process to ascertain how skilled candidates are in MS Excel.

Mercer| Mettl's online Excel test helps evaluate a candidate’s intermediate proficiency in using Excel features, such as the ability to use excel using shortcuts, functions and formulae, charts, pivot tables, statistical operations and macros. The test consists of questions with different difficulty levels to assess candidates' skills objectively and accurately. This test will enable hiring managers to select candidates with the best caliber. In addition, they can conduct assessments in a secure, controlled environment with features such as webcam proctoring, limited system access, and window violation.

Screening eligible candidates for the next stage of the hiring process becomes easy with Mercer| Mettl’s online Excel test. In addition, the test result reports offer a holistic insight into the candidates' performance, which is crucial in making objective hiring decisions.

Designed by subject matter experts, this Microsoft Excel test provides a comprehensive review of candidate's technical knowledge to use this tool effectively and efficiently. The skills of the candidate are assessed on three levels - easy, medium and difficult. This skills assessment test contains 30 questions to be completed in 40 minutes.

Mercer | Mettl’s online Excel test includes a set of specific application-based questions to measure the technical knowledge of a candidate on the following aspects:

  • Ability to use functions and formulae to analyze the data
  • Ability to turn raw data into decision points using PivotTables
  • Ability to perform statistical analysis to support decision making
  • Ability to use graphs and charts to represent data
  • Ability to automate your spreadsheets using macros and advanced functions

Key profiles the test can be used for:

  • Senior Executive or Administrative Assistants
  • Office Managers or Human Resource Assistants    
  • Sales, Marketing and Operations Executives


This Assessment is a part of following Skills Libraries

Microsoft Excel Competency Framework

Get a detailed look inside the test

Competency Under Scanner

Intermediate Excel


Tables and Tools

Demonstrating an ability to interpret large amount of data using tables, charts, graphs, etc. for providing useful insights to the business.

Formulas and Functions

Demonstrating an ability to use MS Excel functions and formulas like vlookup, sumif, count, etc. to perform simple and complex calculations on large amounts of data.

Macros and VBA

Demonstrating an ability to use macros and VBA to automate repetitive and routine tasks to conduct the work faster and efficiently reducing the turnaround time.


Demonstrating an ability to present data in a presentable and correct manner for the reader to focus on the important parts of the worksheet which adds more value to the data.

Customize This 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 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

Simple 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

Saranya Mukherjee
Anson Mathews
Arpan Anand
Sanjeev Phatak
Raphael Beuthner
Gede Agus Putrawirawan
Lisa Guinovart

Mercer | Mettl''s platform and the science behind it are highly intuitive and systematic for the test-takers. Customized assessments, how data is aggregated, and how you can download insightful reports directly from the system - stood out for us from more

Saranya Mukherjee

Saranya Mukherjee

Lead, Early Career Development Campus & Employer Branding

Download Case Study

The ease of navigating the platform, the simplicity of the assessment reports, the ability to adapt to the COVID-19 situation -all of these helped us reduce bad hires, ensure successful probations and onboard individuals with the right set of compete more

Anson Mathews

Anson Mathews

Organization Development Manager, Averda

Download Case Study

We had short timelines in which we had to scale up our workforce. From customized solutions, ease of usability, building an in-depth understanding of the client''s problem to seamless integration with our applicant tracking system, Mercer | Mettl''s more

Arpan Anand

Arpan Anand

CHRO, Aditya Infotech Limited (CP PLUS)

Download Case Study

Mercer | Mettl came across as one of the most robust platforms for AI-based proctoring. The team was accommodative, flexible and prompt. Mercer | Mettl''s team never gave ''no'' as an answer. The team was always upfront about the specifications and c more

Sanjeev Phatak

Sanjeev Phatak

Director, Centre For Management Services, AIMA

Download Case Study

Now that we have used Mercer | Mettl, we will undoubtedly continue to use its platform for the rest of eternity because of our great experience. more

Raphael Beuthner

Raphael Beuthner

CIO, EBZ Business School, Germany

Download Case Study

Once people have undergone Mercer | Mettl''s assessments, we are not worried about their technical prowess. We believe they can be developed further to contribute to Telkom''s survival in the digital world. more

Gede Agus Putrawirawan

Gede Agus Putrawirawan

Manager - Business Planning and Performance, Telkom Indonesia

Download Case Study

We are considering shifting our mid-term and entrance exams completely to the online mode. Mercer | Mettl''s customer service is top-notch, very responsive, and helpful in answering queries. We are delighted with the service provided. more

Lisa Guinovart

Lisa Guinovart

Assoc. Director, The Assessment Center, Miami Dade College

Download Case Study

Frequently Asked Questions (FAQs)

Yes, we can do so selectively. Please write to us for such a request, and we would be glad to assist. 

Yes, we can do so selectively. Please write to us with such a request, and we would be glad to work out a solution for you.

Trusted by More Than 6000 Clients Worldwide

Looking for a solution for *






2023 Mercer LLC, All Rights Reserved

Terms of Services

Privacy Notice


GDPR Compliance