Excel for Marketing Managers

(Dana P.) #1

Index


Charts, cont.
Line, 207, 208, 216, 217
Move, 190, 208, 217
Pie, 185-187, 191-199
Angle of First Slice, 194
Plot Area, 191
Resize, 191, 208, 217
Series, 216
Titles, 208, 217
Checking Homework, 75, 76
Circular Reference, 99, 103-110, 143
Circular Reasoning, 109, 167
Coefficients, 221-223, 226-227, 231, 232
Columns
Headers, Hide, 95, 114, 139, 156, 189
Hide, 65, 189
Width, 20, 21, 35, 42, 127
Adjust Multiple Non-contiguous, 224
Comma as 1000 Separator, 78
Concatenation, 64
Operator, 64
Conditional Format, 80-83, 101, 102, 111, 112,
130, 134, 151, 152, 210
Conditional Responses, 110, 112, 151
Coordinate Grid, 35-43, 99
Handouts, 49, 41
Insert in Word Document, 40
Count, 17
Cubes and Cube Roots, 14


D

Data Points, 193, 194
Data Ranges, 15, 48, 187
Decimal Places, 78
Division, 10
Division Operator, 10


Dollar Signs ($), Enter, 48-50, 154
Drawing Tools, 37-40, 117, 212
Arrow, 39
Line, 39, 120
Oval, 40, 41, 172, 173
Rectangle, 212
Duplicate Problems, 65, 66

E
Edit mode. See also Show Formulas Mode, 74
Equals Sign (=), 1, 3, 6
Equations, Systems of, 219-232
Dependent, 232
Identical, 232
Inconsistent, 231
Exercise Sheets, 53-64
Exponents, 12, 13, 14
Extend a Series, 45-52, 71, 177
Dates, 52
Days, 51
Months, 50
Periods, 50
Weekdays, 51

F
Fill Color Tool, 41, 76, 77
Fill Handle, 45, 46, 50-52, 71-73, 91, 92, 107,
177, 178
Fonts, 69, 82, 89, 94, 100, 110-113, 129-133,
135-137, 144-150, 155, 160, 171, 174, 180,
181, 220
Color, 61
Size, 56
Format
Conditional, 80-83, 111, 130, 151, 152, 210
Copy, 77, 92
Lock, 87
Free download pdf