Page 185 - Excel Progamming Weekend Crash Course

k540629 ch12.qxd 9/2/03 9:34 AM Page 160

160 Saturday Afternoon

REVIEW
One of Excel’s most powerful features is the capability to perform customized calculations by
creating formulas in worksheet cells. This session showed you how to create these formulas
in your VBA programs.
Most formulas perform calculations on data in other cells and must include a reference
to the source cell(s).
A cell reference can be either absolute or relative.
A formula can reference a cell in another worksheet or workbook.
The operators available for use in Excel formulas are similar to the VBA operators.
Circular references, in which two cells refer to each other, must be avoided.
Worksheet formulas can be calculated automatically or under the control of your
program.

QUIZ YOURSELF
1. What is the difference between an absolute and a relative cell reference? (See the
“Cell References in Formulas” section.)
2. How does a formula reference a cell in another worksheet in the same workbook?
(See the “Referencing Cells in Other Worksheets and Workbooks” section.)
3. Does Excel have the same logical operators as VBA? (See the “Logical Operators”
section.)
4. How would you determine if a worksheet contains any circular references? (See the
“Avoiding Circular References” section.)
5. When would you want to use manual formula calculation? (See the “Controlling
Formula Calculation” section.)