Question

Which of the following is the path to the Financial button and the PMT function?

a) Home > Insert > Financial > PMT
b) Formulas > Financial > PMT
c) Data > Financial > PMT
d) Review > Financial > PMT

Answer 1

The path to the Financial button and the PMT function in Excel is Formulas > Financial > PMT, used to calculate loan payments based on constant payments and interest rates.

Step-by-step explanation:

The correct path to the Financial button and the PMT function in Microsoft Excel is Formulas > Financial > PMT. When you want to calculate the payment for a loan based on constant payments and a constant interest rate, you use the PMT function. The PMT function can be found under the Financial functions category within the Formulas tab in Excel.