Shared Flashcard Set

Details

Excel 2007- chapter 2 notes
inserting formulas in a worksheet
12
Other
11th Grade
02/10/2009

Additional Other Flashcards

 


 

Cards

Term
ctrl + '
Definition
to turn off display of formulas
Term
PMT function
Definition
finds the peridodic payment for a loan based on constant interest rate. contains the arguments in NPER, pv,fv, and Type.
Term
nper argument
Definition
is the number of payments that will be made to an investmetn
Term
Pv
Definition
is the current value of amunts to be recieved or paid in the future
Term
FV
Definition
is the value of a loan or investments at teh end of all periods
Term
Type
Definition
determines wheter calculations will be based on paymes made in arreears (at the end of each period) or in advance (at the begining of each period
Term
Now function
Definition
return sthe serial number of the current date and time .
Term
DAte function
Definition
return a serial number that represtnets a particaler date
Term
Relative CEll reference
Definition
where a formula is copied other locations in a worksheet
Term
fill drop down list
Definition
clik the desired direction
Term
smart tag
Definition
a button thatt pops up bear the actice cell
Term
argument
Definition
may consist of a soncstant, cell reference , or another function
Supporting users have an ad free experience!