In Excel, which function is used to calculate the internal rate of return for a series of cash flows? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the internal rate of return for a series of cash flows?

A. PV

B. RATE

C. NPV

D. IRR

Answer: Option D

Solution (By JKSSB Mock Tests)

IRR calculates the internal rate of return. NPV calculates net present value, PV present value, RATE interest rate.

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 'Print' preview in MS Office?

A. All of the above

B. Ctrl + P

C. Ctrl + F2

D. Alt + F, P

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+F2 opens print preview in some apps, Ctrl+P opens print dialog/backstage, Alt+F,P also opens print. So all are valid.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut key configuration used to expand or collapse the entire top menu Ribbon interface bar across MS Office products?

A. Ctrl + F1

B. Ctrl + F2

C. Alt + F1

D. Ctrl + Shift + R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + F1 is the universal keyboard shortcut to hide or show the main Ribbon tools layout menu to maximize screen workspace real estate.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, what does the 'VLOOKUP' function stand for?

A. Vector Lookup

B. Vertical Lookup

C. Variable Lookup

D. Value Lookup

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
VLOOKUP stands for Vertical Lookup, used to search for a value in the first column of a table and return a value in the same row from another column.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs