| |
Skills
Test Sample Report.
| Test
Results for: |
J. Smith |
|
Email : |
jmith@abc.com |
| Company
Name : |
Your
Company |
| Company
ID: |
10159 |
| Test
Administrator/Recruiter's Email : |
info@assessmentleaders.com |
| Test
Name : |
Microsoft Excel 2003 - Normal User |
| Test
Date : |
1/23/2005 |
| Elapsed
Time : |
00:10:46 |
| Questions
Correct : |
26 out of 30 |
| Percent
Correct : |
87% |
| Percentile
Ranking : |
80 |
| Global
Average : |
72% |
Detail Score Report |
| Q# |
Status |
Topic |
Type |
Level |
Time |
| 1 |
Correct |
Opening
Workbook |
Application
Basics |
Basic |
00:00:28 |
| 2 |
Correct |
Insert
Rows |
Insert
Procedures |
Basic |
00:00:07 |
| 3 |
Correct |
Cutting
and Pasting Text |
Application
Basics |
Basic |
00:00:11 |
| 4 |
Correct |
Center
Across Columns |
Formatting
Cells |
Intermediate |
00:00:10 |
| 5 |
Correct |
Editing
Cells |
Application
Basics |
Basic |
00:00:27 |
| 6 |
Correct |
Text
Wrap |
Formatting
Cells |
Advanced |
00:00:13 |
| 7 |
Correct |
Text
Alignment |
Formatting
Cells |
Basic |
00:00:21 |
| 8 |
Correct |
Font/Font
Size |
Formatting
Cells |
Basic |
00:00:24 |
| 9 |
Correct |
Font
Style |
Formatting
Cells |
Basic |
00:00:05 |
| 10 |
Correct |
Format
Number |
Formatting
Cells |
Basic |
00:00:11 |
| 11 |
Correct |
Save |
Application
Basics |
Basic |
00:00:08 |
| 12 |
Correct |
Selecting
Cells |
Formatting
Cells |
Basic |
00:00:09 |
| 13 |
Correct |
Borders |
Formatting
Cells |
Basic |
00:00:39 |
| 14 |
Incorrect |
Print
Scaling |
Formatting
a Worksheet |
Intermediate |
00:00:26 |
| 15 |
Correct |
Navigating
in a Worksheet |
Application
Basics |
Basic |
00:01:33 |
| 16 |
Correct |
Use
SUM Function |
Formulas
and Functions |
Basic |
00:00:58 |
| 17 |
Correct |
Paste
a Function |
Formulas
and Functions |
Intermediate |
00:00:11 |
| 18 |
Incorrect |
Column
Width |
Formatting
a Worksheet |
Basic |
00:00:31 |
| 19 |
Correct |
Insert
Column |
Insert
Procedures |
Intermediate |
00:00:09 |
| 20 |
Incorrect |
Use
AVERAGE Function |
Formulas
and Functions |
Intermediate |
00:00:24 |
| 21 |
Correct |
Insert
Worksheet |
Insert
Procedures |
Advanced |
00:00:05 |
| 22 |
Correct |
Renaming
a Worksheet |
Formatting
a Worksheet |
Advanced |
00:00:22 |
| 23 |
Incorrect |
Insert
Chart |
Insert
Procedures |
Advanced |
00:00:40 |
| 24 |
Correct |
Page
Orientation |
Formatting
a Worksheet |
Basic |
00:00:13 |
| 25 |
Correct |
Margins |
Formatting
a Worksheet |
Basic |
00:00:24 |
| 26 |
Correct |
Header/Footer |
Formatting
a Worksheet |
Intermediate |
00:00:25 |
| 27 |
Correct |
Print
Center on Page |
Formatting
a Worksheet |
Advanced |
00:00:19 |
| 28 |
Correct |
Spell
Check |
Application
Basics |
Basic |
00:00:13 |
| 29 |
Correct |
Save
As |
Application
Basics |
Basic |
00:00:16 |
| 30 |
Correct |
Print
Worksheet |
Application
Basics |
Basic |
00:00:04 |
| Question
Level Statistics |
| |
Number
of Questions |
Number
Correct |
Total
Percentage |
| Basic
|
19 |
18 |
95% |
| Intermediate
|
6 |
4 |
67% |
| Advanced
|
5 |
4 |
80% |
| Total |
30 |
26 |
87% |
| Question
Type Statistics |
| |
Number
of Questions |
Number
Correct |
Total
Percentage |
| Application
Basics |
8 |
8 |
100% |
| Formatting
a Worksheet |
7 |
5 |
71% |
| Formatting
Cells |
8 |
8 |
100% |
| Formulas
and Functions |
3 |
2 |
67% |
| Insert
Procedures |
4 |
3 |
75% |
| Total |
30 |
26 |
87% |
| Test
Description |
Microsoft
Excel 2003 is a popular spreadsheet application. It is included in
Microsoft Office Package, which also includes Word and PowerPoint.
The Microsoft Excel 2003 Whole Test combines both the Normal and Power
User Test.
The Microsoft Excel 2003 Normal User test is designed to test clerical
level users of Excel who are required to edit, develop and create
Excel Workbooks. This test assesses the user's ability to create and
develop a basic Excel workbook, including the most commonly used commands
for formatting cells, navigation through the application, using formulas
and changing the overall appearance of the spreadsheet.
The Microsoft Excel 2003 Power User test attempts to provide the basis
for separating candidates who possess limited exposure to Microsoft
Excel 2002 from those who are conversant with the full functionality
of the software. The primary topics include advanced formatting and
formula writing.
This test is designed to test candidates who will be required to use
some of the more advanced features of the program, while the bulk
of their responsibilities fall within conducting more basic level
activities.
Tests for Microsoft Excel 2002 and Microsoft Excel 2000 are also available.
|
- Test takers,
please contact your test administrator or recruiter for scoring
guidelines.
- Administrators,
please refer to the Scoring Guidelines page within the Resources
section of your Administration Center for scoring guidelines.
|
|
|