| Skill
Sets |
Activities |
| Create
workbooks |
 | electronic workbooks
 | Enter text and numbers
 | Enter formulas
 | Save workbooks
 | Close workbooks |
| | | |
|
| Modify
workbooks |
 | Delete cell contents
 | Delete worksheets
 | Revise text and numbers
 | Rotate and indent text
 | Revise formulas
 | Copy and move data
 | Insert, modify, and delete rows and columns
 | Use references (absolute, relative, and mixed)
 | Sort data |
| | | | | | | |
|
| Print
workbooks |
 | Preview and print worksheets
 | Print the screen and ranges
 | Print headers and footers |
| |
|
| Format
worksheets |
 | Modify cell size and alignment
 | Apply general numbers formats
 | Apply font formats
 | Apply outlines |
| | |
|
| Create
and apply Ranges |
 | Create and name ranges
 | Clear and format ranges
 | Copy and move ranges |
| |
|
| Use
functions |
 | Use the AVERAGE, MIN, and MAX functions
 | Use worksheet functions |
|
|
| Use
draw |
 | Create and modify lines and objects
 | Create and modify 3D shapes |
|
|
| Use
Charts |
 | Create, format, and modify charts
 | Preview and print charts |
|
|
| Save
spreadsheets as HTML |
 | Save spreadsheets as HTML documents |
|