Microsoft Office Specialist Exam Skill Standards: Excel 2003

Microsoft Office Excel 2003

Updated: July 9, 2007
Skill Sets Exam Skill Standards

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


Top of pageTop of page