Excel97pro
Back Home Up Next

Microsoft Excel 97 Proficient Goals:

If you want to create these types of documents... Then your goal should be...
Budgets
Marketing and sales reports
Expense reports
Invoices and purchase orders
Basic financial statements
Spreadsheet information for use on the Intranet/Internet
Microsoft Excel 97 Proficient User


Excel 97 Proficient Exam Objectives
The table below lists the skill sets and activities performed by individuals identified as Proficient User.

Skill Sets Activities
Create workbooks
electronic workbooks
Enter text and numbers
Enter formulas
Save workbooks
Close workbooks
Modify workbooks
Delete cell contents
Delete worksheets
Revise text and numbers
Rotate and indent text
Revise formulas
Copy and move data
Insert, modify, and delete rows and columns
Use references (absolute, relative, and mixed)
Sort data
Print workbooks
Preview and print worksheets
Print the screen and ranges
Print headers and footers
Format worksheets
Modify cell size and alignment
Apply general numbers formats
Apply font formats
Apply outlines
Create and apply Ranges
Create and name ranges
Clear and format ranges
Copy and move ranges
Use functions
Use the AVERAGE, MIN, and MAX functions
Use worksheet functions
Use draw
Create and modify lines and objects
Create and modify 3D shapes
Use Charts
Create, format, and modify charts
Preview and print charts
Save spreadsheets as HTML
Save spreadsheets as HTML documents
Cyber Networks Sitemap home0 5 6