hw: ch 3, midlevel exercises and capstone

what is left?
Financial functions, in depth
Goal Seek
Solver
Pivot Tables
(Mixed references)
Go thru the practice exams

Financial functions, in depth
__________________________
time value of money

Present Value
Future Value
how many times am i collecting interest
what is the interest rate

relative vs. absolute references

A1 -- relative reference
$A$1 -- absolute reference

A1 style
r1C1 style

what happens when your formula is wrong?
how do you find the "bug" and fix it?
Grace Hopper
http://en.wikipedia.org/wiki/Grace_Hopper

Sum function
range operator
:
cell ref : cell ref

hw: midlevel and capstone exercises, ch 2, excel

To err is human; to really fowl things up takes a computer.

Excel
colon operator
is the range operator
A1:B6

relative references

HW:
Excel ch 1, mid-level exercises 1-5, capstone exercise