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 97 Fundamentals

Description:

Our MS Excel 97 Fundamentals test is part of our fundamentals line of business applications tests. These tests demonstrate that you have the skills necessary to proficiently use the most popular business applications at a user level. These tests are focused on the topics used daily by most professionals and do not include some of the advanced topics and skills found in our core business applications tests. The core test in this area is our MS Excel 97 test. Our MS Excel 97 Fundamentals test covers the following topics: Cells, Data/Charts, Menu, Multiple Sheets, Presentation and Appearance, Printing, Ranges, and VBA (Macros).

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
Active Cell and Ranges
Alignment
AutoFill Commands
AutoFormat
Clearing
Comments
Conditional Formatting
Cut, Copy, Paste
Dates
Drag and Drop
Editing
Entering Data
Formatting
Hide/Unhide Rows and Columns
Inserting/Deleting Rows and Columns
Navigating/Selecting
Non-Contiguous
Problems
Sizing
Undo
Charting
Creating Charts
Formatting Charts
Data
Custom Criteria
Filtering Lists
Sorting
Formulas
Creating
Functions
Linking
Operators
Relative/Absolute
Interface/Printing
Headers/Footers
Interface Options
Menu Shortcut Keys
Menus
Page Setup
Toolbars
Workbooks
Creating, Opening, Closing, and Saving
Printing
Templates
Worksheets
Move, Copy, Insert, Delete
Naming
Navigating
Panes/Freeze
Protection
Select/Deselect