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. PMT

C. NPER

D. FV

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

In PowerPoint, 'Handout Master' allows you to set the layout for:

A. Slide transitions

B. Speaker notes

C. Printed handouts with multiple slides per page

D. Slide thumbnails

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Handout Master formats printed handouts.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, a 'Navigation form' is used to:

A. Enter data

B. Create tables

C. Print reports

D. Provide a menu system to open forms and reports

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Navigation form acts as a switchboard.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, which data type is best for a field that stores employee ID numbers that are not used in calculations?

A. Currency

B. AutoNumber

C. Short Text

D. Number

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
If not used in calculations, Short Text is suitable for alphanumeric IDs.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs