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.
Availability
Ready to Use
Test Type
Domain
Experience Level
4-7 years
Difficulty Level
Moderate
Test Duration
40 Minutes
Total Questions
30 Questions
Relevant Job Roles
Office Managers or Human Resource Managers, Senior Executive or Administrative Assistants
Scores Reported
English
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
SKILL LIBRARY
This Assessment is a part of following Skills Libraries
Microsoft Excel Competency Framework
Get a detailed look inside the test
Competency Under Scanner
Competencies:
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.
Formatting
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
Our Customers Vouch for Our Quality and Service
Frequently Asked Questions (FAQs)
1. 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.
2. 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 with such a request, and we would be glad to work out a solution for you.