In Excel, which function returns the remainder after division? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the remainder after division?

A. INT()

B. MOD()

C. ROUND()

D. QUOTIENT()

Answer: Option B

Solution (By JKSSB Mock Tests)

MOD(number, divisor) returns remainder. QUOTIENT returns integer portion of division, INT rounds down, ROUND rounds to digits.

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 function returns the largest number in a range that meets a condition?

A. DMAX()

B. MAXIFS()

C. MAXIF()

D. LARGEIF()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
MAXIFS (Excel 2019+) returns maximum based on criteria.

This question belongs to: Computer Microsoft Office

Question #2

In Access, which of the following is used to create a query that asks for user input?

A. Select Query

B. Crosstab Query

C. Action Query

D. Parameter Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Parameter queries prompt for input.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, the 'Ctrl + Alt + F' shortcut inserts:

A. A page number

B. A hyperlink

C. An endnote

D. A footnote

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Alt+F inserts a footnote. Ctrl+Alt+D inserts endnote.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs