Page 466 - Excel for Scientists and Engineers: Numerical Methods
P. 466
Index
A
ABS worksheet function 256,279 function 292
active cell, reference to 35
add a breakpoint 55, 56 Array keyword 53
add a shortcut key 15 array
Add Trendline.. . 298,299 of values as a result 52
Add Watch ... 55, 57 dimensioning 43
Add, Change, Delete (Solver dynamic 45
parameters) 324 multidimensional 44
Add-In function macros 53 one-dimensional 48
Add-In macro, create an 53 size of 44
Add-Ins 303 variable type of 44
AddIns folder 53 arrays 43,51,57,64
addition, matrix 58 scaling 64
additional matrix functions 63 As keyword 50
Address property 1 16 ASCII codes 429
alternating series 69 assignment statements. 16
Analysis ToolPak 289,303,343,347, Assume Linear Model (Solver options)
425 325
And keyword 17,25 Assume Non-Negative (Solver
approximation error 1 10 options) 325
area
between two curves 132 B
of an ellipse 144 backward difference 99, 103
of an irregular polygon 3 54 Bairstow's method 166
underacurve 127, 129, 130, 131, baseball trajectory (problem) 242
132 bisection method 149
argument, Boolean keyword 29
data type of 49 boundary-value problem 245
optional 50 branching 24
arguments, breakmode 56
two ways to specify 34 breakpoint 55
with or without parentheses 34 Buffon's needle (example) 350
indefinite number of 5 1 buttons parameter of MsgBox 40
naming 11, 17 By Changing Cell (Goal Seek) 158,
operators 17 181
Arr (custom function) 65,297 By Changing Cell (Solver) 323
array By Changing Cells box 320
constants 71
443
