Microsoft Office Specialist Exam Skill Standards: Excel 2002
Microsoft Office Excel 2002
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 |
