Banner
Banner
Contact usLogin
online-assessment
online-assessment
online-assessment
/assets/pbt/aboutTest.svg
/assets/pbt/skills.svg
/assets/pbt/customize.svg
/assets/pbt/features.svg
Core Corporate Functions>Sales>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

MS Excel Competency Framework

Get a detailed look inside the test

Competency Under Scanner

Basic Excel

Competencies:

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

Frequently Asked Questions (FAQs)

Benchmarks can be provided selectively for assessments at global, industry, or organizational levels. Please contact us at 'mettlcontact@mercer.com’ with your request for benchmarks to be evaluated by the Mercer | Mettl analytics team.

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.