Certification

Microsoft Office Specialist Exam Skill Standards: Excel 2003 Core

Creating Data and Content

• Enter and edit cell content
• Locate specific cell content
• Locate, select, and insert supporting information
• Insert, position, and size graphics

Analyzing Data

• Filter lists using the AutoFilter feature
• Sort lists
• Insert and modify formulas
• Use statistical, date and time, financial, and logical functions
• Create, modify, and position diagrams and charts based on worksheet data

Formatting Data and Content

• Apply and modify cell formats
• Apply and modify cell styles
• Modify row and column formats
• Format worksheets

Collaborating

• Insert, view, and edit comments

Managing Workbooks

• Create new workbooks from templates
• Insert, delete, and move cells
• Create and modify hyperlinks
• Organize worksheets
• Preview data in other views
• Customize window layout
• Setup pages for printing
• Print data
• Organize workbooks using file folders
• Save data in appropriate formats for different uses

Back to Microsoft Office Specialist Exams