In Excel, which function is used to calculate the number of periods for a loan? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the number of periods for a loan?

A. PV

B. PMT

C. NPER

D. RATE

Answer: Option C

Solution (By JKSSB Mock Tests)

NPER calculates the number of payment periods.

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

In Excel, which of the following functions rounds a number up, away from zero?

A. ROUND()

B. CEILING()

C. ROUNDDOWN()

D. ROUNDUP()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
ROUNDUP rounds up. CEILING also rounds up but to a specified multiple. ROUND rounds to nearest digit.

This question belongs to: Computer Microsoft Office

Question #2

To convert text to uppercase in Excel, which function is used?

A. LOWER()

B. PROPER()

C. UPPER()

D. CAPITAL()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
UPPER makes all letters uppercase. PROPER capitalizes each word's first letter, LOWER makes all lowercase.

This question belongs to: Computer Microsoft Office

Question #3

What is the default font and size in MS Word 2016?

A. Calibri, 12 pt

B. Calibri, 11 pt

C. Times New Roman, 12 pt

D. Arial, 10 pt

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Default font is Calibri 11 pt since Word 2007.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs