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

Question

Share Report Error

In Excel, which function is used to calculate the net present value?

A. NPV

B. FV

C. IRR

D. PV

Answer: Option A

Solution (By JKSSB Mock Tests)

NPV calculates net present value.

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

What is the shortcut key to open the 'New Comment' in MS Word?

A. Alt + M

B. Ctrl + Shift + M

C. Ctrl + M

D. Ctrl + Alt + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Alt+M inserts a comment.

This question belongs to: Computer Microsoft Office

Question #2

Which of the following is the shortcut to save the current workbook in Excel?

A. F12

B. Alt + F4

C. Ctrl + Shift + S

D. Ctrl + S

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + S saves. F12 opens Save As. Alt + F4 closes Excel.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, what does the error '#N/A' mean?

A. Invalid cell reference

B. Name not recognized

C. Division by zero

D. A value is not available to a function or formula

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
#N/A indicates no value available, common in lookup functions.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs