Excel for Marketing Managers

Index

References
Absolute, 49, 154, 178, 227
Mixed, 45, 49
Relative, 49
Relative References. See also Absolute and Mixed
References, 49
Right-justify Text, 55, 56
Roots, 12-14
Rows
Headers, Hide, 95, 139, 156
Height, 19, 20, 36
Insert, 59

S

Scroll Bars, Hide, 189
Series, Extend, 45, 50-52, 71, 177
Dates, 52
Days, 51
Months, 50
Periods, 50
Weekdays, 51
Shortcut Keys
Alt+Enter, 202, 203, 212, 221, 222
Ctrl+1. See Cells, Format, 22, 33, 36, 100,
110, 112, 129, 133-137, 144-147, 149,
150, 155, 171, 174, 180, 181, 186, 198,
225, 226, 229
Ctrl+A, 75
Ctrl+C, 40, 42, 46, 57, 70, 73, 77, 93, 98,
122, 148, 164, 213, 224, 227-229
Ctrl+D, 132, 155, 206, 215
Ctrl+Enter, 48, 162
Ctrl+V, 42, 57, 70, 73, 122, 148, 161, 224,
227, 228
Ctrl+Z, 120
F2, 74
F4, 49, 50
F9, 55, 58, 59, 72, 73, 105, 108, 109, 111-
113, 147, 153, 155, 158, 167, 169-171,
174, 177, 179, 181, 198, 199
Home, 118
Shift+Spacebar, 64
Show Formulas Mode. See also Edit Mode, 72, 85
Sigma (∑). See also AutoSum Button, 15

Simultaneous Equations. See Systems of

Equations, 219, 231

Snap To Grid, 38, 40, 119, 172, 212

Spelling, AutoCorrect, 146

Square Roots, 12-14

Start New Line, 202, 203, 212, 221, 222

Story Problems, 1-18

String Art, 117-121, 123, 124

Subtraction, 3-8, 11, 15, 16, 62-64, 86, 219, 220

Sums, 141

Systems of Equations, 219-233

Dependent, 232

Identical, 232

Inconsistent, 231

T

Tabs

Copy, 162

Delete, 162

Hide, 95, 114, 139, 156, 189

Move, 162

Rename, 163

Tesselations, 117, 121-123

Text

Alignment, 69, 88, 93, 100, 110, 133, 144,

149, 150, 160, 171, 180, 181

Center, 56, 77

Find and Replace, 163

Hide, 61, 112, 155, 189

Right-/Left-justifying, 55

Wrap, 94, 113, 137, 145, 181, 221, 222

Touch-Typing Method, 1, 2

Transposition, 45-47, 98

V

Volume of a Cube, 13

Volume Formula, 215

W

Width Formula, 206, 209, 211, 215