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 |
|
