Question

What does the PMT function do in Excel?

A Calculates the principal payment for a loan Correct Answer Incorrect Answer
B Calculates the payment for a loan based on constant payments and a constant interest rate Correct Answer Incorrect Answer
C Calculates the total payment for a loan Correct Answer Incorrect Answer
D Calculates the present value of an investment Correct Answer Incorrect Answer

Solution

The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate.

Practice Next

Relevant for Exams:

×
×