USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
PMT, PV, and FV are functions found in which Function Library category?
|
|
Financial
|
|
|
Logical
|
|
|
Math & Trig
|
|
|
Statistical
|
Explanation:
Detailed explanation-1: -The PMT Function[1] is categorized under financial Excel functions.
Detailed explanation-2: -The PMT function can also be found in the Formulas tab, Function Library group, Financial command drop down menu.
Detailed explanation-3: -The PPMT Function[1] is categorized under Excel Financial functions. The function will calculate the payment on the principal for a loan or an investment based on periodic, constant payments and a fixed interest rate for a given period of time.
Detailed explanation-4: -Formula for PV in Excel NPER = Number of payment periods. PMT = Amount paid each period (if omitted-it’s assumed to be 0 and FV must be included)
There is 1 question to complete.