What is a spreadsheet, GUI overview
Select Cell
Entering Data - Text, fixing errors, autocorrect
Entering data - numbers
Calc Sum
Fill - fill handle
Formatting: Font type, size, style color, mergin cells
Name box to select cell (EX36)
Add chart
AutoCalculate
-----
Formulas: order of ops, point mode vs fill mode vs manually
Functions: average, min, max, count
Verifying formulas
Formatting: BG colors, borders, number formats, conditional formatting, widths/heights
Spell check
Print formulas version
-------
Rotate text
fill series
Copy formulas - copy/paste vs drag-n-drop
Insert/delete
Format symbols
Freeze titles
Functions: IF
Formatting: numbers, titles, shadows
Charts: Pie
Multiple worksheets
What-if & Goal seeking (EX204 ff.)
Thursday, March 30, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment