CIS111E Chapter 7- Specialized Functions

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

1. 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
2. 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.
3. NOT function (p. 426)

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

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

=INDEX(array,row_num,[column_num]
Returns a value or a reference to a value within a range
6. Database functions (p. 435)
Analyzes data for selected records in a table.
7. DSUM function (p. 436)

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

=DAVERAGE(database,field,criteria)
Averages values in a database column based on specified conditions.
9. DMAX function (p. 437)

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

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

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

=DCOUNTA(database,field,criteria)
To count records containing an empty cell.
13. 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.
14. IPMT function (p. 443)

=IPMT(rate,per,nper,pv,[fv],[type])
Calculates periodic interest for a fixed-term, fixed-rate loan or investment.
15. 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.
16. CUMIPMT function (p. 444)

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

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

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

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

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

=NPER(rate,pmt,pv,[fv],[type])
Calculates the number of periods for an investment of loan.
22. 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.
 Author: davecowman ID: 310243 Card Set: CIS111E Chapter 7- Specialized Functions Updated: 2015-10-25 23:15:06 Tags: Chapter7 Folders: Description: Specialized Functions Show Answers: