Excel Notes

Card Set Information

Author:
rbussell07
ID:
2072
Filename:
Excel Notes
Updated:
2009-12-01 22:01:06
Tags:
excel
Folders:

Description:
exam 3 exam notes
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user rbussell07 on FreezingBlue Flashcards. What would you like to do?


  1. 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.
  2. Relative reference
    when the "fill handle" is dragged and formulas change automatically adjusting for the new position.
  3. Absolute reference
    when the "fill handle" is dragged the same cell reference is kept where a "$" is added.
  4. Pivot Table
    an interactive table enabling you to quickly group and summarize large amounts of data
  5. Loan Payment Formula
    Payment=(i + [ i/ [(1+i)loan term]-1]) x loan amount
  6. Payment Function
    • -given yearly interest rate and yearly loan term
    • PMT=(r/12, loan term x 12, -loan amt)
  7. 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
  8. IF
    logical function which checks to see if a condition is met, and returns one value if TRUE, and another if FALSE.

What would you like to do?

Home > Flashcards > Print Preview