Excel assessment test to assess candidates' knowledge of functions and formulas

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