-combines sheet reference and cell reference
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
Loan Payment Formula
-given yearly interest rate and
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.
exam 3 exam notes