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

Question

Share Report Error

In Excel, the 'PMT' function calculates:

A. Loan payment amount

B. Interest rate

C. Future value

D. Present value

Answer: Option A

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 option is used to insert a video from a file?

A. Insert > Object

B. Insert > Media > Video

C. Insert > Video > This Device

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You can insert video from file via Insert > Video > This Device (or Similar).

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, the 'Ctrl + D' shortcut opens:

A. Document properties

B. Font dialog

C. Paragraph dialog

D. Date picker

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+D opens Font dialog.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, which object is used to present data in a printed format with headers, footers, and grouping?

A. Form

B. Table

C. Query

D. Report

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Reports are designed for printing and often include grouping and summaries.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs