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.
Availability
Ready to Use
Test Type
Domain
Experience Level
0-1 year
Difficulty Level
Easy
Test Duration
40 Minutes
Total Questions
30 Questions
Relevant Job Roles
Office Managers or Human Resource Managers, Personal and Executive Secretaries, Executive or Administrative Assistants, Office Managers or Human Resource Assistants, Office Managers or Human Resource Assistants, Office Managers or Human Resource 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. 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
SKILL LIBRARY
This Assessment is a part of following Skills Libraries
MS Excel Competency Framework
Get a detailed look inside the test
Competency Under Scanner
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
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 customised 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.