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 2000

Description:

Our MS Excel 2000 test measures your knowledge of MS Excel 2000. Designed for experienced users, this test covers the following topics: Cells, Charts, Data, Formulas, Interface, Objects, Print Setup, Ranges, VBA, and Worksheets.

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

Sample Test
$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
Borders
Comments
Conditional Formatting
Dates
Drag and Drop
Edit and Clear
Insert/Delete
Number Formats
Charts
Edit
Labels and Text
Pivot Charts
Placement
Type
Data
External Data
Filters
Forms
Pivot Tables
Sorting
Tables
Validation
What-If Analysis/Goal Seek
Formulas
Addition Through the Worksheet
Creating
Edit
Error Handling/Auditing
Familiarity (Which-When-How, etc.)
Relative and Absolute Addresses
Interface
Add-Ins
Help System
Shortcut Keys
Split Screen/Freeze Panes
Toolbars
Workspace
Objects
Autoshapes
Formats
Hyperlinks
Pictures
Print Setup
Headers/Footers
Margins
Page General Options
Sheet Setup
Ranges
Edit Name
Naming
Non-contiguous
Selecting Ranges
Styles/AutoFormat
VBA
Code
Macros
Record, Naming
Worksheets
Grouping
Internet/Intranet -Interactivity
Moving
Naming
Protection
Wizard