basic excel

Table of Contents for Topic 1I. Organization...5
II. Movement and Cell Entries...5
A. Movement...5
B. Data entry...5
C. Entering formulas...6
D. Editing cell entries...7
E. Entering a series of data...7
F. Exercise 1—Data and Formula Entry...9
III. Spreadsheet Window...10
A. Descriptions of spreadsheet view...10
B. Zoom view...10
C. Window splitting and freezing...10
D. Formula displaying and auditing...10
E. Create a new sheet...11
F. Range names...12
G. Goto command (F5)...12
IV. Formatting...13
A. Cell formatting...13
B. Justification buttons...13
C. Number formatting (decimal buttons)...14
D. Font, color, etc. (including buttons)...14
E. Borders (including color)...14
F. Format painter...15
G. Wrapping text...15
H. Column and row widths and heights...15
I. Selecting column or row or noncontiguous ranges...16
J. Inserting/deleting columns, rows, cells, and cell contents...16
K. Page and print formatting...18
V. Copying and Moving Cell Contents...18
A. Background...18
B. Copying a value from a single cell...18
C. Copying from multiple contig