Home
Flashcards
Preview
Excel Notes
Home
Get App
Take Quiz
Create
3-D Reference
-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.
Relative reference
when the "fill handle" is dragged and formulas change automatically adjusting for the new position.
Absolute reference
when the "fill handle" is dragged the same cell reference is kept where a "$" is added.
Pivot Table
an interactive table enabling you to quickly group and summarize large amounts of data
Loan Payment Formula
Payment
=(
i
+ [
i
/ [(
1
+
i
)
^{loan term}
]-
1
]) x
loan amount
Payment Function
-given yearly interest rate and
yearly
loan term
PMT=(r/12, loan term x 12, -loan amt)
VLOOKUP
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
IF
logical function which checks to see if a condition is met, and returns one value if TRUE, and another if FALSE.
Author
rbussell07
ID
2072
Card Set
Excel Notes
Description
exam 3 exam notes
Updated
2009-12-02T03:01:06Z
Show Answers
Home
Flashcards
Preview