Excel for Marketing Managers

(Dana P.) #1

Index


M

Magic Squares, 87-98
Manual Calculations. See also Automatic
Calculation, 55, 58, 73, 103, 105, 143, 153,
167, 168, 177, 198
Margins, 26, 27, 42, 68, 125
Math
Exercise Sheets, 53-59, 63, 64
Operators and Functions, 1, 2, 4-11, 55, 77
Mathematical Art, 117
String Art, 117-120, 123, 124
Tesselations, 117, 121-123
Maximization, 201, 210-215
Area of a Rectangle, 201-206, 209, 210
Volume of a Box, 211-215
Maximum Value, 17
Minimum Value, 17
Minus Signs (-), 3-8, 11
Mixed References. See also Absolute and Relative
References, 45, 48, 49
Mouse Method. See also Arrow and Touch-Type,
3, 5, 12
Multiplication, 9, 11, 45, 47, 59-62, 67, 73, 76-
79, 84, 165
Intermediate Steps, 84-86
Operator. See Asterisk, 9, 77
Multiplication Tables, 45, 47, 73


N


Nested IF Statements, 110, 151
New Line, 202, 203, 212-222
Numbers, Format, 78, 133, 186, 214, 215


O

Order of Operations, 11
Overridden by Parentheses, 11


P

Page Break Preview, 28
Page Setup, 26, 28, 34, 42, 67, 97, 125
Parentheses, Control Order of Operations, 11
Passwords, 96, 140, 157, 175, 182, 230
Percentages, 167, 185
Pie Charts, 185-199
Angle of First Slice, 194
Show Fractions, 185-188, 192-199
Plus Signs (+), 7, 55, 64, 73
Pound Signs (#), 74, 224
Powers, 12-14
Print Area, Set, 29-34
Print Gridlines, 26
Print Preview, 22, 28, 31, 34, 42, 125
Print Settings, 26, 28, 29
Products, 86, 143, 148
Protection, Files, 96, 97, 114, 140, 157, 175,
176, 182, 183, 198, 199, 230
Pythagorean Theorem, 12, 13

Q
Quizzes, 67-73
Quotation Marks, 55, 56, 106

R
Random Numbers, 53, 54, 66, 67, 71, 72, 99,
104, 153-155, 167, 171
Ranges, 15, 48, 187
Select, 69
Turn on Side, 45, 46, 98
Read-only Files, 169, 176, 184
Free download pdf