Excel for Marketing Managers

(Dana P.) #1

Index


Index


A

Absolute References. See also Relative and Mixed
References, 49, 154, 178, 227
Addition, 1-3, 5-8, 11, 12, 15, 16, 54-57, 62-67,
73, 84, 86, 183
Alignment, 56, 69, 70, 88, 93, 100, 110, 113,
133-137, 144-150, 160, 161, 171, 174, 180,
181, 220, 221
Ampersand (&), 64
Analysis ToolPak, 53, 54
Answer Keys, 60
Apostrophes, 55, 223, 226
Area Formula, 206, 209
Area of a Rectangle, 201-206, 209, 215
Arrow Key Method, 5-7
Art, 117
String Art, 117-121, 123, 124
Tesselations, 117, 121-123
Asterisk, 9, 50
AutoFill, 45
Automatic Calculation. See also Manual
Calculation, 3, 58, 75, 103, 153, 168, 177,
198
AutoShapes, 39, 40, 120-123
Align, 119, 213
Format, 41, 173, 213
Move, 41, 122, 173
Resize, 40, 41, 173
Transparency, 173
AutoCorrect Spelling, Disable, 146
AutoSum, 15-18
Average, 17-18


B

Borders, 22-25, 33, 36, 55, 68, 70, 77, 88, 94,
100, 113, 118, 119, 129, 133, 137, 145-149,
160, 161, 180, 181, 221

C
Calculations, 143
Automatic, 3, 58, 75, 103, 153, 168, 177, 198
Manual, 55, 58, 103, 105, 109, 143, 153,
168, 177, 198
Calculus and Pre-Calc, 201
Carat (^), 12, 13, 55, 77
Cartesian Coordinate Grid, 35-42, 99
Handouts, 41-42
Insert in Word Document, 35, 40
Cells
Alignment, 202
Color, 41, 76, 188
Copy, 57, 224
Format, 22-25, 36, 68-70, 78, 81, 88-94, 100,
102, 113, 129, 133, 136, 144-150, 152,
155, 160, 161, 170, 171, 174, 180, 181,
186, 188, 202-206, 212, 214, 215, 220,
221, 225, 229
Locked and Unlocked, 96, 114, 140, 157,
175, 182, 199, 230
Merge, 93, 94, 113, 134, 150, 160, 161, 174,
181, 220-222
Center Text, 55, 77
Chart Wizard, 187, 188, 207, 216
Charts, 188, 202, 207, 211, 216
Customize, 190-193
Data Points, 193, 194
Insert, 187, 208, 217
Labels, 192
Legends, 187
Free download pdf