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

B. NPV

C. RATE

D. PV

Answer: Option A

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

Share Report

Which of the following is NOT a valid type of section break in MS Word?

A. Same Page

B. Odd Page

C. Next Page

D. Even Page

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Section break types: Next Page, Continuous, Even Page, Odd Page.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, the shortcut for 'Select All' is:

A. Ctrl + S

B. Ctrl + Shift + A

C. Ctrl + Alt + A

D. Ctrl + A

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+A selects all.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, the function to return the position of a substring within a string is:

A. FIND()

B. MATCH()

C. SEARCH()

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both FIND and SEARCH return the starting position of a substring. FIND is case-sensitive, SEARCH is not. MATCH is for ranges.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs