.

 

 

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

 

 

 
 
© Copyright totaltesting. All rights reserved. Site Designed and powered by 21Centuryweb.com