MS Excel 2000

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

 

Go Back