In Excel, which function is used to calculate the present value of an annuity? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the present value of an annuity?

A. PV

B. NPER

C. FV

D. PMT

Answer: Option A

Solution (By JKSSB Mock Tests)

PV calculates present value, FV future value, PMT payment, NPER number of periods.

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

What is the shortcut key to open the 'Find and Replace' dialog in MS Word with the Go To tab active?

A. Ctrl + G

B. Ctrl + H

C. Both A and C

D. F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+G and F5 both open the Go To tab of Find and Replace.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which of the following is the extension of a PowerPoint template file?

A. .ppt

B. .ppsx

C. .pptx

D. .potx

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.potx is a PowerPoint template. .pptx is a normal presentation, .ppsx is a show, .ppt is older format.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which Access object provides a structured, formatted output designed for printing?

A. Module

B. Query

C. Report

D. Form

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Reports are for printed output. Forms are on-screen, queries retrieve data, modules contain VBA code.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs