Certification

Microsoft Office Specialist Exam Skill Standards: Excel 2002 Core

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

Back to Microsoft Office Specialist Exams