Microsoft Excel Test - Hire candidates with knowledge of Excel Skills

Hire candidates skilled in Microsoft Excel

Excel is a powerful tool used extensively in most modern businesses. Data holds many insights if organised properly and analysed to track trends. This requires expertise in the software and an application-oriented mindset. This test has been designed to test the proficiency of a candidate in using Excel for statistical analysis.

This test has been designed to assess the excel skills of a potential candidate. It tests the ability to use excel using shortcuts, functions and formulae, charts, pivot tables, statistical operations and macros. The test consists of questions variable in their difficulty levels to accurately identify candidates that have proficiency in MS Excel.    

What does Mettl Microsoft Excel Test measure?

Microsoft Excel - Intermediate Level is a test specially designed to assess the skills of a candidate to use Microsoft Excel effectively and efficiently. This test measures the technical knowledge of a candidate on the following aspects through a set of specific application-based questions.

  • Use functions and formulae to analyse the data
  • Turning raw data into decision points using PivotTables and PowerPivots
  • Performing What-if, sensitivity and statistical analysis to support decision making
  • Use graphs and charts to represent data
  • Automating your spreadsheets using macros and advanced functions

Top Customers

Looking for a customised test?

Are you looking for a customised version of this test. Or looking to get a new test build according to your requirements from scratch? Reach out to our subject matter experts and discuss the same.


Microsoft Excel - Intermediate Level consists of the following critical competencies given below:

  • Formulas and Functions: Ability to easily edit large amounts of data while pertaining to the necessary MS Excel functions and formulas.

  •  Macros and VBA: Ability to work faster and efficiently by recording actions into a macro and automating the tasks in Microsoft Excel.

  •  Formatting: Ability to sort and present data while keeping it in a presentable format, apply conditional formatting and manage worksheets to achieve the project objective.

  • Tables and Tools: Ability to filter large amounts of data available and summarize data in the form of tables, graphs and charts. 

Test Details:

Number of Sections 4                                                                                   
Number of Questions 30
Test Duration 30 Mins
Language English

Key profiles that the test can be useful for:

This test is useful for freshers as well as experienced candidates in any industry. Some notable ones include:

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

Answer to common queries:

Can I get benchmark scores for the candidates who take this assessment for hiring decisions?

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

Can I get customized reports for the candidates who take this assessment, for example, to highlight the most important competency?

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.


How it works:

step 1
Mettl-PBT-1

Add this test to your tests

step 2
Mettl-PBT-2

Share test link from your tests

step 3
Mettl-PBT-3

Candidate take the tests

step 4
Mettl-PBT-4

You get their tests report


Note You will be charged only at step 3. i.e. only when candidate start the test.


Relevant for Industries

  • IT
  • ITeS
  • Banking & finance
  • FMCG
  • Retail