In Excel, the 'PMT' function calculates: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the 'PMT' function calculates:

A. Present value

B. Interest rate

C. Future value

D. Loan payment amount

Answer: Option D

Solution (By JKSSB Mock Tests)

PMT returns periodic payment.

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

Share Report

In MS PowerPoint, which pane allows you to add speaker notes?

A. Slides pane

B. Notes pane

C. Outline pane

D. Task pane

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Notes pane (below the slide in Normal view) is where you type speaker notes. Outline pane shows text outline.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In PowerPoint, which shortcut is used to delete a selected slide?

A. Ctrl + D

B. Backspace

C. Esc

D. Delete key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Pressing Delete removes the selected slide. Backspace also works in some contexts but Delete is standard.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, the formula =IF(A1>10, IF(A1>20, "High", "Medium"), "Low") will return what if A1=15?

A. Error

B. Low

C. Medium

D. High

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A1=15, first condition >10 true, then nested IF: A1>20 false, so "Medium".

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs