Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MS Excel 2002

Description:

Our MS Excel 2002 test, part of our Office XP suite, measures your knowledge of Excel 2002. Designed for experienced users, this test includes the following topics: Cells, Charts, Data, Formulas, Interface, Objects, Printing, VBA, Workbook, and Worksheets.

This test is associated with a Job Role. Please visit the Job Role Center for more details.

$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline


Cells
Comments
Conditional Formatting
Dates
Edit and Clear
Error Checking Smart Tag
Excel Border Drawing
Insert/Delete
Charts
Data Labels
Formatting
Labels and Text
Options
Pivot Charts
Type
Data
External Data
Filtering/Sorting
Formatting
Pivot Tables
Validation
Formulas
Absolute Reference
AutoSum
Common Functions
Complex Functions
Creating
Evaluator
Function Wizard
Interface
Help
Protection
Sharing
Speech
Toolbars/Menus
Objects
Autoshapes
Clip Art
Formats
Hyperlinks
Printing
Page Setup
Print Area
Print Preview
VBA
Code
Macro Recorder
Userforms
Workbook
Application and Document Recovery
Auto Recover
Defined Names
Repair and Extract
Worksheets
Grouping
Moving
Split Screen/Freeze Panes
Tab Colors/Naming
Web Components