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
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
...read more
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
...read more
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
...read more
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
...read more
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.
...read more
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.
...read more
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.
...read more
Lisa Guinovart
Assoc. Director, The Assessment Center, Miami Dade College
Download Case Study
Related Tests
Related Products
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.
