82.3k views
4 votes
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

User Funk
by
8.2k points

1 Answer

2 votes

Final answer:

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.

User Mohinder
by
8.1k points