|
SAMPLE SCORES
EXCEL 2003 -
STANDARD
|
|
|
|
eTicket Number: |
5454952085379739877 |
|
Issued to: |
tests@totaltesting.com |
|
|
|
Name: |
Test Taker Name |
|
ID: |
123 |
|
Company Name: |
ABC Company |
|
Date: |
1/26/2007 |
|
Time: |
16:42 |
|
Time Taken: |
21 minute(s) |
Performance
Overview
|
|
|
|
|
SCORE: |
80% (28/35) |
|
Percentile
ranking: |
76 |
|
|
|
All
recorded scores: |
|
|
Number of
scores: |
47246 |
|
|
Average score: |
65% |
Performance
Analysis
LEVELS
|
|
Score |
Correct |
Total |
|
BEGINNER: |
93% |
14 |
15 |
|
INTERMEDIATE: |
69% |
9 |
13 |
|
ADVANCED: |
71% |
5 |
7 |
TOPICS
|
|
Score |
Correct |
Total |
|
FILE
MANAGEMENT: |
67% |
2 |
3 |
|
EDITING: |
78% |
7 |
9 |
|
FORMATTING: |
100% |
8 |
8 |
|
TOOLS AND
AUTOMATION: |
33% |
1 |
3 |
|
ANALYSIS: |
75% |
6 |
8 |
|
PRINTING: |
100% |
4 |
4 |
QUESTIONS
|
Q # |
Topic |
Name |
Status |
Time (# secs) |
Level |
|
19 |
ANALYSIS |
Absolute Cell
Address |
Incorrect |
27 |
ADV |
|
20 |
ANALYSIS |
Sort -
Multilevel |
Correct |
21 |
ADV |
|
21 |
ANALYSIS |
Function -
Insert |
Correct |
36 |
INT |
|
22 |
ANALYSIS |
Function -
Statistical (MINA) |
Incorrect |
17 |
ADV |
|
23 |
ANALYSIS |
Function -
Autosum |
Correct |
12 |
INT |
|
26 |
ANALYSIS |
AutoFilter -
Select |
Correct |
33 |
ADV |
|
27 |
ANALYSIS |
Chart - Create |
Correct |
46 |
ADV |
|
28 |
ANALYSIS |
Chart - Change
Type |
Correct |
17 |
ADV |
|
2 |
EDITING |
Cut Cells |
Correct |
27 |
BEG |
|
3 |
EDITING |
Paste Cells |
Correct |
7 |
BEG |
|
4 |
EDITING |
Undo |
Correct |
8 |
BEG |
|
5 |
EDITING |
Fill Cells |
Incorrect |
28 |
INT |
|
6 |
EDITING |
Delete Cells |
Incorrect |
10 |
BEG |
|
7 |
EDITING |
Insert Row |
Correct |
21 |
BEG |
|
8 |
EDITING |
Replace Text |
Correct |
22 |
INT |
|
17 |
EDITING |
Select Column |
Correct |
10 |
BEG |
|
24 |
EDITING |
Spell Check |
Correct |
8 |
INT |
|
1 |
FILE MANAGEMENT |
Create New
Workbook - Template |
Incorrect |
40 |
INT |
|
9 |
FILE MANAGEMENT |
Save Workbook |
Correct |
19 |
BEG |
|
29 |
FILE MANAGEMENT |
Rename
Worksheet |
Correct |
16 |
INT |
|
10 |
FORMATTING |
Align Cell
Contents |
Correct |
6 |
BEG |
|
11 |
FORMATTING |
Border Lines |
Correct |
11 |
ADV |
|
12 |
FORMATTING |
Number Format -
Currency |
Correct |
23 |
INT |
|
13 |
FORMATTING |
AutoFit Column |
Correct |
9 |
BEG |
|
14 |
FORMATTING |
Hide Column |
Correct |
12 |
INT |
|
18 |
FORMATTING |
Font Size |
Correct |
10 |
BEG |
|
31 |
FORMATTING |
Margins |
Correct |
23 |
BEG |
|
32 |
FORMATTING |
Paper Size |
Correct |
15 |
BEG |
|
30 |
PRINTING |
Set Print Area |
Correct |
11 |
INT |
|
33 |
PRINTING |
Scale Worksheet |
Correct |
22 |
BEG |
|
34 |
PRINTING |
Print Preview |
Correct |
38 |
BEG |
|
35 |
PRINTING |
Print Workbook |
Correct |
18 |
BEG |
|
15 |
TOOLS AND
AUTOMATION |
Zoom |
Correct |
9 |
INT |
|
16 |
TOOLS AND
AUTOMATION |
Range Name -
Create |
Incorrect |
25 |
INT |
|
25 |
TOOLS AND
AUTOMATION |
Protect Cells |
Incorrect |
17 |
INT |
|