Formula auditing

debugging your formulas
evaluate formula is one suich debugging tool

trace precedents (draws arrows...)
trace dependents (draws arrows...)

Relative reference - get changed as copy formula
Absolute reference - stays put

Using the Name Box, you can give Names to Absolute references

FUNCTION is basically a named operator

+-*/^

5 + 4
5 and 4 are operands

SQRT
SQRT(16)
operands we call parameters or arguments

we covered some basic functions


Number formatting:
There is a diff between the actual value stored in a cell and the way it displays.

Superman III, Office Space
maybe use the round function

Read through Ch 5 in the Lecture Book
Do quickchecks
No Quiz next week. Instead, a Word exam


IF function
VLOOKUP function

Do Practice Exercises for ch 2 in Excel
(you might want to also look at the mid-level exercises, since that won't have as much hand-holding, and you want to be able to develop and intuition about writing formulas, to prepare for the Excel hands-on exam.)