Start Excel | E 1.06-08 | high |
Customize Excel Window | E 1.09 | low |
Design a worksheet | E 1.10 | high |
Workbooks and sheets | E 1.10-11 | high |
Cells and their names | E 1.11 | high |
Scrolling and menus | E 1.12 | high |
Select and enter | E 1.16-22 | high |
Compute sums, averages, min, max, percentages | E 1.23-28, 2.15-21 | high |
Copy cells | E 1.25, 2.23 | high |
Formatting | E 1.28-33, 2.26-48, 3.07,3.32-43 | moderate |
Use Name Box to Select Cell | E 1.35 | moderate |
Charts | E 1.37-40, 1.52 | high |
Save, print, quit, open | E 1.40-47 | high |
Correct, Undo, Clear (at least one way) | E 1.49-52 | high |
Get help | E 1.52-54 | high |
Enter formulas (at least one way) | E 2.09-24 | high |
Copy Formulas | E 2.13 | moderate |
Verify a Formula | E 2.25 | moderate |
Apply formats, at least one way | E 2.34-37 | moderate |
Apply Conditional Formatting | E 2.40 | moderate |
Change Height of Row, Width of Column | E
2.44-47 | high |
Check Spelling | E 2.49, 3.56 | moderate |
Print and preview | E 2.51-58, 3.57 | moderate |
Display Formulas; Fit Printout | E 2.56 | moderate |
Change Print Scaling Option | E 2.58 | low |
Import Data from Web | E 2.59 | low |
Rename Sheet | E 2.62 | high |
E-mail a workbook | E 2.63 | low |
Fill Series | E 3.08 | moderate |
Rotate Text | E 3.08 | low |
Copy Cell's Format | E 3.11 | moderate |
Copy Range of Cells to Nonadjacent Destination | E 3.14 | high |
Insert a row | E 3.17 | high |
Enter number with format symbol | E 3.19 | moderate |
Enter and format date | E 3.23 | moderate |
Enter formula with absolute references | E 3.26 | moderate |
Enter IF function | E 3.28 | moderate |
Copy using fill handle | E 3.30 | moderate |
Freeze and unfreeze column and row titles | E 3.31,36 | moderate |
Assign Formats to Nonadjacent Ranges | E 3.33 | moderate |
Display/hide drawing toolbar | E 3.38 | moderate |
Dock Toolbar at Bottom of Screen | E 3.39 | low |
Add Drop Shadow | E 3.40 | low |
Draw chart on separate sheet | E 3.44 | high |
Change colors of pie slices | E 3.50 | low |
Explode pie chart | E 3.51 | moderate |
Rotate and Tilt Pie Chart | E 3.52 | low |
Goal seek | E 3.53 | low |
Add Leader Lines to Data Labels | E 3.54 | moderate |
Rename and Reorder Sheets | E 3.55 | moderate |
Shrink and Magnify View | E 3.58 | moderate |
Split into panes; remove panes | E 3.60-61 | moderate |
Analyze Data by Changing Values | E 3.62 | high |