What is the purpose of the PMT function in Excel? MCQ with Answer and Explanation

Question
What is the purpose of the PMT function in Excel?
A. Calculates the periodic payment for a loan based on constant payments and interest rate
B. Returns the present value of an investment
C. Projects the future value of an investment
D. Converts a number to text with currency format
Answer: Option A
Solution (By JKSSB Mock Tests)
PMT(rate, nper, pv) computes loan payment. FV returns future value, PV present value.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In PowerPoint, which option lets you play a sound across multiple slides?
A. Slide Show -> Set Up Show -> Play Narrations
B. Insert -> Media -> Sound from File
C. Audio Tools Playback -> Play Across Slides
D. Animations -> Add Animation -> Sound
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Select the audio icon, then in Audio Tools Playback tab, check 'Play Across Slides'.
This question belongs to: Computer Microsoft Office
Question #2
What is the default slide layout for a new slide in PowerPoint?
A. Comparison
B. Title and Content
C. Title Slide
D. Blank
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
When you add a new slide (Ctrl+M), the default layout is Title and Content.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if:
A. A1/B1 results in any error value
B. Only if #DIV/0!
C. If A1 is blank
D. If B1 is zero
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
IFERROR catches all error types and returns specified value.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?