Report Section
Microsoft Excel - Intermediate Level_old
Test Taker Details
s
sample1
Email Address: sample.mettl@mettl.com
Executive Summary
Performance Summary:
This test has been designed to assess the MS Excel skills of a candidate. It tests the ability to use excel for filtering, sorting, representing data, and formatting. It also tests the usage of VLOOKUP, Hlookup, Macros, VBA and other excel functions. The test consists of questions variable in their difficulty levels to accurately identify candidates that have proper knowledge of MS excel.
Values shown in above chart are percentages
Recommendation
Moderately Recommended
Not Recommended
Moderately Recommended
Recommended
Evaluation of Domain Competencies:
Values shown in above chart are percentages
1. Evaluation of Domain Competencies:
Formulas and Functions: Low
Shows low understanding of MS Excel functionalities like formula, functions, VLOOKUP, Hlookup, etc. May not be comfortable using the software for performing calculations using formulas and operating on values in a range of cells using MS Excel functions, VLOOKUP, Hlookup, etc.
Macros and VBA: Moderate
Shows an average understanding of MS Excel functionalities like macros, VBA, etc. Moderately likely to be comfortable using MS Excel to automate tasks in MS Excel using macros including everyday Excel tasks to clean-up and format data.
Formatting: High
Shows good understanding of MS Excel functionalities like formatting, conditional formatting, data validation, convert excel types, etc. Likely to be comfortable working on the software to apply correct functions for accurate and timely calculations in order to manage worksheets using formula based techniques like conditional formatting, data validation etc.
Tables and Tools: Very High
Shows excellent understanding of MS Excel functionalities like data tools, graphs and charts, tables, etc. Likely to be comfortable working on the software to create high quality documents consisting of tables, charts, pictures and other advanced tools.
Test Log
Test Log
-
Started the test with MS Excel - Formulas and Functions
-
Finished MS Excel - Formulas and Functions and started MS Excel - Macros and VBA of the test
-
Finished MS Excel - Macros and VBA and started MS Excel - Formatting of the test
-
Finished MS Excel - Formatting and started MS Excel - Tables and Tools of the test
-
Finished the test