Microsoft Excel Whiz 2002 2003

Formatting, 48

Inserting and Deleting Cells, 32-33

Shift Cells Down, 33

Shift Cells Right, 33

Merging and Splitting, 57

Moving Selected Cells, 28-89

Working in using the Formula bar, 66-68

Cell Address, 4, 20, 34

Cell Content, 4

Aligning Cell Content, 56

Aligning Data at the Top, Center, or Bottom of a Cell, 57

Clear Cell Contents and Formats, 31

Editing Cell Content, 27

Formatting, see Formatting Cells

Indenting Text, 58

Merge and Center button, 57

Rotating text, 57

Selecting Non-adjacent Cells, 32, 36

Cell Reference, 34

Absolute, 71

Mixed, 71

Relative, 71

Character Fonts, Size, Styles and Colors, see Formatting Characters

Charts, 130

Axes tab, 134

Category Axis, see X-axis

Chart Wizard, 132

Chart Wizard Dialog box, 132-133

Column, 131

Creating, 130-131

Data labels, 134

Data Table, 134

Gridlines, 134

Legend, 134

Legend Key, 134

Line, 131

Modifying, 135

Options, 133

Pie, 131

Plot Area, 130

Printing, see Printing

Quick Chart, 131

Series, 131

Series point, 131

Titles tab, 133

Types, 131

Value Axis, 131

Value Axis Major Gridlines, see Gridlines

X-axis, 130, 134

Y-axis, 130, 134

Clear Cell Contents and Formats, see Cell Content

Clear Command, 31

Clipart, see Objects

Clipboard, 28-29

Closing Worksheet window, 9

Color-code worksheet tabs, 96

Column, 3-4

Adjusting Columns, 53

Adjusting Column Width, 53-54

Deleting Rows or Columns, 92

Freeze/Unfreeze, 94

Hide/Unhide, 93

Inserting, 32-33, 92

Modify Column Widths, 53

Moving, 28-31

Selecting, 32

Comma Style, see Formatting Numbers

Comments, 106-108

Adding Comments, 106

Creating and Responding to Discussion Comments, 107-108

Deleting Comments, 107

Editing Comments, 107

Viewing Comments, 107

Consolidate data using 3-D References, see Worksheets

Copy, 29-30

Currency Style, see Formatting Numbers

Cut or Move, Copy, and Paste, 28-29, 36

Cut, 29-30, 36 see also Paste, 29-30