Microsoft Excel Test
Overview of Test
Designed to test an individual’s ability to perform tasks within a simulated Microsoft Excel environment. The Microsoft Excel assessment is fully simulated and available at a variety of levels enabling you to assess at a level relevant to both the candidate and the role. A comprehensive report breaks down ability by level, percentile and correct answers.
Available for software versions 2003-2013.
Skills Measured and Levels
Available levels are basic, intermediate and expert. You can choose the level at the point of assignment.
The levels were initially based on Microsoft Training and have been “levelled” in line with real world day to day activities. The levelling is based on a common consensus from Skillsarena’s view, customer feedback and the Skillsarena User Group. Levels assigned to candidates should be chosen as appropriate to the needs of the role. In the vast majority of cases Basic is appropriate and perhaps intermediate in some cases.
Consider that the levels are based on “typical use” of the application; for example basic would cover those tasks that are performed regularly and easily, the majority of times by most people using the application day in day out. More difficult tasks such as those in intermediate and certainly expert levels will only be performed by those that have more in-depth knowledge of the application and typically use far less basic functionality.
Consideration 1: MS Applications are vast in their capabilities and functionality. The majority of us only use around 20% or less of the applications full capability (and don’t need any more than this in the majority of cases).
Consideration 2: Everyone’s opinion of their own level is very different. Levels in the assessments here are based on functionality, complexity and how common a task would be performed in the normal workplace.
For persons who need to demonstrate understanding and capability in MS applications prior to employment or as part of training needs analysis.
Basic. Clear the data in cell B4.
Intermediate. Give the chart on the worksheet “Charts” the title “Staff”.
Expert. In the current worksheet use the filter list option so that only “Electronics” items are displayed.
Microsoft Simulation Excel FactFile
Require bespoke adjustments to these tests?
All assessments can be adjusted to meet your specific needs. Bespoke activities often include the addition of organisation specific questions relating to specific software, company policies and procedures as well as the removal of questions if required.
To find out more about our bespoke assessments, click here.