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

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.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS Word, which specialized feature must be activated to allow footnotes to automatically maintain separate, distinct numbering streams across different chapters?
A. Style Separator
B. Section Break
C. Bookmark
D. Page Break

Correct Answer: Option B


Explanation:
Section breaks divide a document into independent parts with their own formatting, headers, footers, margins, and footnote/endnote numbering properties.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, which chart type shows the proportion of each data series relative to the total using nested rings?
A. Pie
B. Doughnut
C. Sunburst
D. Treemap

Correct Answer: Option B


Explanation:
Doughnut chart is like a pie with a hole, can show multiple series. Sunburst shows hierarchical rings.

This question belongs to: Computer Microsoft Office
Question #3
In MS PowerPoint, which pane allows you to add speaker notes?
A. Notes pane
B. Outline pane
C. Slides pane
D. Task pane

Correct Answer: Option A


Explanation:
The Notes pane (below the slide in Normal view) is where you type speaker notes. Outline pane shows text outline.

This question belongs to: Computer Microsoft Office