‘
Notes on Excel Calculations
EXCEL REVIEW
2001-2002
This handout is meant to serve as a
quick review of some of the principal features
of Excel formulas and calculations. It’s not meant to
cover Excel’s formulas or calculations in great depth.
This guide may jog your memory
about a feature or two you might have used and then forgotten
or introduce you to something new
in Excel that you’d like to explore further.
If you’re not already familiar with a feature described here
and you think it might be useful to you, I hope you’ll
consult Excel’s online help or a good reference guide
for a complete description.
Examples and illustrations are drawn from Excel 2000.
Paula Ecklund
Spring 2001
Contents
Page
I. Formula Basics
The Building Blocks: Values, Cell References, & Operators ..................................1
Excel’s Order of Calculations..................................................................................4
Controlling Calculation in Workbooks ..................................................................5
Entering & Editing Formulas..................................................................................7
Formula-Building Recommendations....................................................................10
Calculating With Date & Time Values ...................................................................11
Replacing a Formula With a Value.........................................................................12
Naming Cells & Ranges Used in Formulas............................................................13
Using a Formula to Name a Range.........................................................................16
Understanding Relative, Absolute, and Mixed Addressing..................................19
How to Display Formulas in a Worksheet.............................................................22
Array Formulas..