In Excel, what does the 'PMT' function calculate? MCQ with Answer and Explanation

In Excel, what does the 'PMT' function calculate?
A. The payment for a loan based on constant payments and interest rate
B. The interest rate of a loan
C. The future value of an annuity
D. The present value of an investment
Answer: Option A
Solution (By JKSSB Mock Tests)
PMT computes the periodic payment for a loan or annuity with constant payments and a fixed interest rate. PV calculates present value, FV future value, RATE calculates interest rate.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
What is the keyboard shortcut to right-align text inside an active cell or text line in MS Word?
A. Ctrl + L
B. Ctrl + E
C. Ctrl + J
D. Ctrl + R

Correct Answer: Option D


Explanation:
Ctrl + R is the universal shortcut to right-align selected text, paragraphs, or active layout structures flush against the right margin in MS Word.

This question belongs to: Computer Microsoft Office
Question #2
What is the keyboard shortcut to insert a hyperlink in MS Excel?
A. Ctrl + I
B. Ctrl + L
C. Ctrl + K
D. Ctrl + H

Correct Answer: Option C


Explanation:
Ctrl + K is the universal shortcut to insert a hyperlink in Microsoft Office applications, including Excel, Word, and PowerPoint.

This question belongs to: Computer Microsoft Office
Question #3
In Word, which of the following is used to create a multilevel list?
A. Review > Multilevel List
B. References > Multilevel List
C. Insert > Multilevel List
D. Home > Multilevel List

Correct Answer: Option D


Explanation:
Multilevel List is in the Home tab, Paragraph group.

This question belongs to: Computer Microsoft Office