Search
Create
Log in
Sign up
Log in
Sign up
Excel - Chapter 7
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (20)
AND Function
A logical test function that returns TRUE when all arguments are true and FALSE when at least one argument is false
CUMIPMT Function
A financial function that calculates cumulative interest for specified payment period
CUMPRINC Function
A financial function that calculates the cumulative principal paid on a loan between specified periods
Database Function
A function that analyzes data for selected records in a table
DAVERAGE Function
A database function that averages values in a database column based on a specific conditions
DCOUNT Function
A database function that counts the cells that contain a number in a database column based on specified conditions
DMAX Function
A database function that identifies the highest value in a database column based on specific conditions
DMIN Function
A database function that identifies the lowest value in a database column based on specific conditions
DSUM Function
A database function that adds value in a database column based on specified conditions
FV Function
A financial function that calculates the future value of an investment given a fixed interest rate, a term, and periodic payments
INDEX Function
A lookup & reference value or reference to a value within a range
IPMT Function
A financial function that calculates periodic interest for a fixed-term, fixed-rate loan or investment
Loan amortization table
A schedule showing monthly payments , interest per payment, amount toward paying off the loan, and the remaining balance for each payment
MATCH Function
A lookup & reference function that identifies a searched item's position in a list
NOT Function
A logical function that returns TRUE if the argument is false and FALSE if the argument is true
NPER Function
A financial function that calculates the number of periods for an investment or loan
NPV Function
A financial function that calculates the net present value of an investment with periodic payments and a discount rate
OR Function
A logical function that returns TRUE if any argument is true and returns FALSE if all arguments are false
PPMT Function
A financial function that calculates the principal payment for a specified payment period given a fixed interest rate, term, and period payments
PV Function
A financial function that calculates the present value of an investment
;