Contact usLogin
    Hire, Engage and Innovate
  • /header/Online-Hackathons.svg
    Hackathons and Ideathons

    Accelerate innovations

Core Corporate Functions>Data Sciences>Microsoft Excel - Basic Level

Excel assessment test to assess candidates' knowledge of functions and formulas

Excel assessment test is designed to assess the basic Excel skills of a potential candidate. Excel assessment tests the candidate's ability to use Excel for filtering, formatting, applying formulas, and other functions.

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. Candidates skilled at Microsoft Excel can use the application to analyze information and visualize data and information in charts, smart arts, and pivot tables. They understand the functions and features of the application, develop practices to minimize time, effort and execute fast operations. There is, therefore, a need to find skilled candidates with expertise in this software and an application-oriented mindset.

Mercer| Mettl’s Excel assessment test is a pre-employment assessment that hiring managers and recruiters can use during the job screening process to assess the basic proficiency of candidates in MS Excel. This Excel competency test evaluates the candidates' basic conceptual knowledge of applying the features, functions, formatting, pivot tables, shortcuts, etc. It also tests the use of pivot tables, shortcuts, hyperlinks, password protection and various other Excel functions. 

Mercer| Mettl’s Excel skills test will help hiring managers 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 and engaging eligible candidates for the next stage of the hiring process becomes easy with Excel proficiency 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 Excel proficiency test provides an in-depth review of the candidate's basic Excel skills. The skills of the candidate are evaluated on three levels - easy, medium and difficult. This test contains 30 questions to be completed in 30 minutes. 

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

  • Ability to effectively organize data, including project plans, budgets, current expenses and other information
  • Ability to analyze and record data to get accurate insights
  • Ability to perform collaborative tasks with others

Key profiles the test is helpful for:

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


This Assessment is a part of following Skills Libraries

MS Excel Competency Framework

Get a detailed look inside the test

Competency Under Scanner

Basic Excel


Facebook Web/Page Analytics

Use the Facebook marketing test to assess the candidate's ability to use Facebook's analytics, post insights, etc., to understand where and how users interact with businesses across Facebook.

MS Excel - Home

Demonstrating an ability to use different view options, file saving options, setting password option, etc. to protect data in the excel files.

MS Excel - Insert

Demonstrating an ability to work faster and efficiently using shortcuts to work on large amount of data, using pivot tables to filter the required data, using charts to present data efficiently and creating hyperlinks in the document which helps in accessing information stored on a network server using internet.

MS Excel - Formula and Functions

Demonstrating an ability to use different formulas and formulas like sum, average, count, if, etc. to perform simple and complex calculations on the data to derive useful insights and present the outcomes in a presentable manner.

MS Excel - Data

Demonstrating an ability to present data in an organized manner and apply filters to sort the data into the given categories.

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

Sonal Kapur Sinha
Anson Mathews
Shirish Awasthi
Mayank Jain
Lisa Guinovart
Ike Marieta
Varun Berry

The validity of Mercer | Mettl''s assessments is exceptionally robust. It enabled us to funnel people who were precisely the type we needed. Mercer | Mettl helped us to accurately identify high-potential candidates within our internal team. more

Sonal Kapur Sinha

Sonal Kapur Sinha

Head HR, Modern Foods

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

Mercer | Mettl''s solutions brought various unprecedented insights into our technical hiring process. It was complemented by reduced friction and enhanced ease and agility. With one of the most advanced and extensive lists of questions and world-cla more

Shirish Awasthi

Shirish Awasthi

Talent Acquisition, Coforge Ltd.

Download Case Study

We had an extremely pleasant experience working with Mercer | Mettl. Thanks to Mercer | Mettl we were able to ensure contuinity in examination. I dont think we could have offered our exams any other way. more

Mayank Jain

Mayank Jain

Manager, Vidyamandir Classes

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

Mercer | Mettl assured us of the quality and consumer service that other platforms were not offering. Security, integrity and technology were unmatched, easy to explain and understand. more

Ike Marieta

Ike Marieta

Director, PIP, Universitas Padjadjaran, INDONESIA

Download Case Study

When you have an assessment platform such as Mercer | Mettl, you have done your homework. You know the candidate is good enough. So you are saving time. more

Varun Berry

Varun Berry

Managing Partner, Operations, Chordify & CEO, Intulog

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 for 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