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.
Ready to Use
Domain
0-1 year
Easy
40 Minutes
30 Questions
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
English UAE, English Singapore, English Philippines, English India, English Indonesia, English Global
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:
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.
Demonstrating an ability to use different view options, file saving options, setting password option, etc. to protect data in the excel files.
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.
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.
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
Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.
Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.
Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.
Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.
The Mercer | Mettl Advantage
Frequently Asked Questions (FAQs)
1. Can I benchmark scores for applicants taking this test when hiring?
Yes, benchmarks can be provided for the test. Please contact mettlcontact@mercer.com for assistance.
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.
