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

Question

Share Report Error

In Excel, the 'PMT' function calculates:

A. Future value

B. Present value

C. Interest rate

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 Access, to import data from an Excel file, you can use:

A. External Data tab -> Import Excel

B. Database Tools -> Import

C. Create tab -> Table from Excel

D. Home tab -> Get External Data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The External Data tab provides import and link options.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, what does 'Widow/Orphan control' prevent?

A. Overlapping text and images

B. A single line of a paragraph at the top or bottom of a page

C. Page breaks before headings

D. Two consecutive hyphens

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Widow/Orphan control keeps at least two lines together at page breaks.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the function of the keyboard shortcut Ctrl + Y in MS Word?

A. Redoes or repeats the last action performed

B. Undoes the last action performed

C. Inserts a time index stamp

D. Cuts the selected item block

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Y is the shortcut to Redo or repeat an action that was reversed via the Undo (Ctrl + Z) command.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs