In Excel, which function is used to calculate the interest rate per period of a loan? MCQ with Answer and Explanation

In Excel, which function is used to calculate the interest rate per period of a loan?
A. IRR
B. NPER
C. RATE
D. PMT
Answer: Option C
Solution (By JKExamLibrary)
RATE calculates interest rate per period.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
In MS Word, the 'Ctrl + Shift + A' shortcut:
A. Toggles all caps
B. Selects all
C. Opens font dialog
D. Applies bold

Correct Answer: Option A


Explanation:
Ctrl+Shift+A toggles UPPERCASE.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS PowerPoint, which of the following is used to apply a theme to a presentation?
A. Home tab > Themes
B. Insert tab > Themes
C. Design tab > Themes
D. Slide Show tab > Themes

Correct Answer: Option C


Explanation:
Themes are on the Design tab.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
What is the keyboard shortcut to double-underline a highlighted block of text characters in MS Word?
A. Ctrl + Shift + D
B. Ctrl + Shift + U
C. Ctrl + U
D. Alt + Shift + D

Correct Answer: Option A


Explanation:
Ctrl + Shift + D applies double-underline formatting to the selected text. Ctrl + U applies a standard single underline.

This question belongs to: Computer Microsoft Office