Page 20 - Excel for Scientists and Engineers: Numerical Methods

PREFACE xvii

Excel's Worksheet Functions and Their Arguments. Worksheet
functions are in Arial font; the arguments are italicized. Following Microsoft's
convention, required arguments are in bold font, while optional arguments are in
nonbold, as in the following:
VLOOKUP(/ookup-value, fab/e-array, column-index-num, range-lookup)
The syntax of custom functions follows the same convention.

Excel Formulas. Excel formulas usually appear in a separate line, for
example,
=I +1/FACT(1)+1/FACT(2)+1/FACT(3)+1IFACT(4)+1/FACT(5)
Named ranges used in formulas or in the text are not italicized, to distinguish
them from Excel's argument names, for example,

=VLOOKU P(Temp,Table, MATCH( Percent, P-Row, 1 )+I,
1
)
VBA Procedures. Visual Basic code is in Arial font. Complete VBA
procedures are displayed in a box, as in the following. For ease in understanding
the code, VBA keywords are in bold.

Private Function Derivl (x)
'User codes the expression for the derivative here.
Derivl = 9 * x 2 + 10 * x - 5
End Function

Problems and Solutions

There are over 100 end-of-chapter problems. Spreadsheet solutions for the
problems are on the CD-ROM that accompanies this book. Answers and
explanatory notes for most of the problems are provided in Appendix 8.

The Contents of the CD
The CD-ROM that accompanies this book contains a number of folders or
other documents:
an "Examples" folder. The Examples folder contains a folder for each
chapter, e.g., 'Ch. 05 (Interpolation) Examples.' The examples folder for
each chapter contains all of the examples discussed in that chapter:
spreadsheets, charts and VBA code. The location of the Excel file pertinent
to each example is specified in the chapter text, usually in the caption of a
figure, e.g.,
Figure 5-5. Using VLOOKUP and MATCH to obtain a value from a two-way table.
(folder 'Chapter 05 Interpolation,' workbook 'Interpolation I,' sheet 'Viscosity')