Home > Preview
The flashcards below were created by user
davecowman
on FreezingBlue Flashcards.

AND function (p. 424)
=AND(logical1,logical2,Value if all conditions are met,Value if at least one condition is FALSE)
Returns True when all arguments are true and FALSE when at least one argument is false

OR function (p. 525)
=OR(logical1,logical2,Value if any argument is TRUE,Value if all arguments are FALSE.
Returns TRUE if any argument is true and returns FALSE if all arguments are false.

NOT function (p. 426)
=NOT(logical)
Returns TRUE if the argument is false and FALSE if the argument is true.

Match function (p. 426)
=MATCH(lookup_value,lookup_array,[match_type])
Identifies a searched item's position in a list.

INDEX function (p. 427)
=INDEX(array,row_num,[column_num]
Returns a value or a reference to a value within a range

Database functions (p. 435)
Analyzes data for selected records in a table.

DSUM function (p. 436)
=DSUM(database,field,criteria)
Adds values in a database column based on specified conditions

DAVERAGE (p. 436)
=DAVERAGE(database,field,criteria)
Averages values in a database column based on specified conditions.

DMAX function (p. 437)
=DMAX(databases,field,critera)
Identifies the highest value in a database column based on specified conditions

DMIN function (p. 437)
=DMIN(database,field,criteria)
Identifies the lowest value in a database column based on specified conditions.

DCOUNT function (p. 437)
=DCOUNT(database,field,criteria)
Counts the cells that contain a number in a database column based on specified conditions.

DCOUNTA function (p. 437)
=DCOUNTA(database,field,criteria)
To count records containing an empty cell.

Loan Amortization Table (p. 442)
A schedule of monthly payments, interest per payment, amount toward paying off the loan, and the remaining balance for each payment.

IPMT function (p. 443)
=IPMT(rate,per,nper,pv,[fv],[type])
Calculates periodic interest for a fixedterm, fixedrate loan or investment.

PPMT function (p. 444)
=PPMT(rate,per,nper,pv,[fv],[type])
Calculates the principal payment for a specified payment period given a fixed interest rate, term, and periodic payments.

CUMIPMT function (p. 444)
=CUMIPMT(rate,nper,pv,start_period,end_period,type)
Calculates cumulative interest for specified payment period.

CUMPRINC function (p. 444)
=CUMPRINC(rate,nper,pv,start_period,end_period,type)
Calculates cumulative principal for specified payment periods.

PV function (p. 445)
=PV(rate,nper,pmt,[fv],[type])
Calculates the present value of an investment

FV function (p. 445)
=FV(rate,nper,pmt,[pv],[type])
Calculates the future value of an investment

NPV function (p. 445)
NPV=(rate,value1,value2)
Calculates the net present value of an investment with periodic payments and a discount rate.

NPER (p. 446)
=NPER(rate,pmt,pv,[fv],[type])
Calculates the number of periods for an investment of loan.

RATE function (p. 446)
=RATE(nper,pmt,pv,[fv],[type])
Calculates the periodic rate for an investment or loan given the number of payment periods, a fixed periodic payment, and present value.

