excel 2010 test results
TRANSCRIPT
Test Results for: Lacey Desper
Company Name: All In One Integration Account
Test Administrator/Recruiter's Email: [email protected]
Test Name: Microsoft Excel 2010 - Normal User
Test Date: 10/22/2013
Elapsed Time: 00:14:21
Questions Correct: 29 out of 30
Percent Correct: 97%
Percentile Ranking: 80
Global Average: 76%
Detail Score Report View only questions answered incorrectly
Q# Status Topic Type Level Time
1 CorrectOpen a
Workbook
General
Commands
and Properties
Basic 00:00:32
2 Correct Insert a RowFormatting
and EditingBasic 00:00:15
3 Correct Font StyleFormatting
and EditingBasic 00:00:04
4 Correct Font SizeFormatting
and EditingBasic 00:00:09
5 CorrectFormat Cells
as Currency
Formatting
and EditingBasic 00:00:05
6 Correct SUM Function Formulas Intermediate 00:00:10
7 Correct CopyFormatting
and EditingBasic 00:00:07
8 CorrectPaste a
Function
Formatting
and EditingBasic 00:00:11
9 Correct Save
General
Commands
and Properties
Basic 00:00:09
10 CorrectText
Alignment
Formatting
and EditingBasic 00:00:10
11 Correct Selecting Cells General Basic 00:00:08
Commands
and Properties
12 Correct BordersFormatting
and EditingIntermediate 00:00:12
13 CorrectRenaming a
Worksheet
General
Commands
and Properties
Basic 00:00:31
14 Correct Insert ColumnFormatting
and EditingBasic 00:00:09
15 CorrectUse AVERAGE
FunctionFormulas Advanced 00:00:11
16 Correct Column WidthFormatting
and EditingIntermediate 00:00:06
17 Correct Insert Chart Insert Tools Intermediate 00:00:20
18 Correct Chart Styles Insert Tools Basic 00:00:14
19 Correct Text WrapFormatting
and EditingIntermediate 00:02:04
20 CorrectInsert
Worksheet
General
Commands
and Properties
Basic 00:00:10
21 CorrectMerge and
Center Cells
Formatting
and EditingAdvanced 00:00:05
22 Correct SortFormatting
and EditingIntermediate 00:00:17
23 Correct Margins Page Layout Basic 00:00:20
24 CorrectPage
OrientationPage Layout Basic 00:00:07
25 Correct Header/Footer Insert Tools Intermediate 00:00:34
26 Correct Spell Check
General
Commands
and Properties
Basic 00:00:12
27 CorrectPrint Centered
on PagePage Layout Advanced 00:00:19
28 IncorrectCreate
PivotTableInsert Tools Advanced 00:04:52
29 Correct Print Scaling Page Layout Intermediate 00:01:24
30 CorrectPrint
Worksheet
General
Commands
and Properties
Basic 00:00:14
Question Level Statistics
Number of Questions Number Correct Total Percentage
Basic 18 18 100%
Intermediate 8 8 100%
Advanced 4 3 75%
Total 30 29 97%
Question Type Statistics
Number of Questions Number Correct Total Percentage
Formatting and Editing 13 13 100%
Formulas 2 2 100%
General Commands and Properties 7 7 100%
Insert Tools 4 3 75%
Page Layout 4 4 100%
Total 30 29 97%
Test Description
Microsoft Excel 2010 is a popular spreadsheet application. It is included in the Microsoft Office Package, which also includes
Word and PowerPoint. The Microsoft Excel 2010 - Whole Test combines both the Normal and Power User Test.
The Microsoft Excel 2010 - 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 2010 - Power User test attempts to provide the basis for separating candidates who possess limited
exposure to Microsoft Excel 2010 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 on a regular basis.
Tests for Microsoft Word and Microsoft Outlook 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.