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