Test Results for: |
J. Smith |
Email : |
jmith@abc.com |
Company Name : |
Your Company |
Company ID: |
10159 |
Test Administrator/Recruiter's Email : |
info@stafftesting.com |
Test Name : |
Microsoft Excel 2003 - Normal User |
Test Date : |
1/23/2004 |
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. |
|