Excel - Chapter 7 Latest 2023 Rated A+
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 ca
...
Excel - Chapter 7 Latest 2023 Rated A+
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, fixedrate 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
[Show More]
