MOUS Tests: Excel 97 Proficient and Expert

clogo.gif (12135 bytes)

Excel 97 Proficient and Expert Specialists

This page describes how to prepare for the Microsoft® Office Specialist exam in Microsoft Excel 97. Use the following table of typical documents to determine the appropriate level of certification for your skills and goals.

Use the table below to determine the level that you should attain. The table beginning on the following page lists specific activities for each of the document types.

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
Accounting/financial statements Data analysis Statistical tables Amortization schedules Forecasts Personnel records Lists	Microsoft Excel 97 Expert 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	Open 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

Excel 97 Expert Exam Objectives
Expert Users must be able to perform all activities listed for Proficient Users in addition to the activities listed in the table below.

Skill Sets	Activities
Format worksheets	Apply formats (accounting, fraction, and scientific) Create custom formats Use styles and autoformats
Use lists	Sort data Query from a list
Print workbooks	Preview workbooks Print workbooks
Audit a worksheet	Check and review data Find cells referred to in a specific formula Find formulas that refer to a specific cell Find errors
Use advanced functionality	Query databases Extract data Use filters Use data analysis and pivot tables Use data map Use data validation Use conditional formatting Perform multi-level sorts
Use macros	Create and record macros Edit macros Run macros
Import and export data	Import from other applications Export to other applications
Use templates	Work with existing templates Create templates Edit templates
Use multiple workbooks	Link workbooks Use multiple workbooks
Use workgroup functions	Cell tips Share lists Track changes Resolve conflicts Show history of changes Merge workbooks