|
Exam skill standards are categories of examination tasks, identified
by subject-matter experts, that certify an ability to productively use
Microsoft Office programs. These categories are organized into skill sets
representing the more basic functions of each Office program.
Exam skill standards for the Microsoft Excel 2002 Exam are provided below
to assist in your exam preparation. Training centers and courseware
providers authorized by the Microsoft Office Specialist (Office Specialist)
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
|
