Shared Flashcard Set

Details

Advance Formulas
?
12
Other
11th Grade
02/16/2009

Additional Other Flashcards

 


 

Cards

Term
PMT Function
Definition
Finds the periodic payments for a loan based on constant interest rate.
Term
FV Function
Definition
Calculates the future value of a series of equal payments or an annuity
Term
NOW Function
Definition
Returns the seriel number of the current date and time
Term
DATE Function
Definition
Resturns the seriel number that represents a particular date
Term
IF function
Definition
you can perforn conditional tests on values and formulas
Term
logical test
Definition
performs a particular action if the answer is true and another action is the answer if false
Term
3 parts
Definition
the condition or logical test IF(quota=>1000000).
Term
Edit a formula
Definition
click the enter button ont he formula bar and excel will recalculate the result of the formula
Term
Nested IF condition
Definition
two possible actions - the actual sales times 15% or a zero
Term
relative cell references
Definition
refer to cells relative to a position in a formula
Term
Absolute reference
Definition
refer to cells in a speficific location
Term
Mixed cell reference
Definition
either the column remains absolute and the row is relative or the column ius relative and the row is absolute
Supporting users have an ad free experience!