Excel Notes

• -combines sheet reference and cell reference
• -example: SUM(sheet1:sheet3!B1:B3) adds all the values from B1 to B3 in all the sheets from sheet 1 to sheet 3.

when the "fill handle" is dragged and formulas change automatically adjusting for the new position.

when the "fill handle" is dragged the same cell reference is kept where a "$" is added.

an interactive table enabling you to quickly group and summarize large amounts of data

Payment=(i + [ i/ [(1+i)^{loan term}]-1]) x loan amount

• -given yearly interest rate and yearly loan term
• PMT=(r/12, loan term x 12, -loan amt)

looks for a value from a given cell in the leftmost column of a table and then returns a value in the same row from the column you specify

logical function which checks to see if a condition is met, and returns one value if TRUE, and another if FALSE.