Excel - Chapter 7 Latest 2023 Rated A+

Document Content and Description Below

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]

Last updated: 2 years ago

Preview 1 out of 4 pages

Buy Now

Instant download

We Accept: