|
| |
EXCEL EXAM OBJECTIVES:
MY STATUS: NOT TAKEN YET
Exam objectives are categories of examination tasks, identified by
subject-matter experts, that certify an ability to productively use Microsoft
Office applications. These categories are organized into skill sets representing
the more basic functions of each Office application.
Exam objectives and skill sets for the Microsoft Excel 2002 Core Exam are
provided below to assist in your exam preparation. Training centers and
courseware providers authorized by the Microsoft Office User Specialist (MOUS)
program tailor their instruction to these criteria.
Working with Cells and Cell Data
 | Insert, delete and move cells
| Enter and edit cell data including text, numbers, and formulas
| Check spelling
| Find and replace cell data and formats
| Work with a subset of data by filtering lists |
| | | |
Managing Workbooks
| Manage workbook files and folders
| Create workbooks using templates
| Save workbooks using different names and file formats |
| |
Formatting and Printing Worksheets
| Apply and modify cell formats
| Modify row and column settings
| Modify row and column formats
| Apply styles
| Use automated tools to format worksheets
| Modify Page Setup options for worksheets
| Preview and print worksheets and workbooks |
| | | | | |
Modifying Workbooks
| Insert and delete worksheets
| Modify worksheet names and positions
| Use 3-D references |
| |
Creating and Revising Formulas
| Create and revise formulas
| Use statistical, date and time, financial, and logical functions in
formulas |
|
Creating and Modifying Graphics
| Create, modify, position, and print charts
| Create, modify, and position graphics |
|
Workgroup Collaboration
| Convert worksheets into Web pages
| Create hyperlinks
| View and edit comments |
| |
|
