In Excel, which function is used to find the remainder after division? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to find the remainder after division?

A. DIV

B. REMAINDER

C. MOD

D. QUOTIENT

Answer: Option C

Solution (By JKSSB Mock Tests)

MOD returns the remainder of a division. QUOTIENT returns the integer portion.

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, the 'Status Bar' can display:

A. Ribbon commands

B. Cell reference

C. Sum, Average, Count of selected cells

D. Formula

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Status bar shows quick calculations.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which data type stores a calculated value that depends on other fields?

A. Calculated

B. Number

C. Memo

D. AutoNumber

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Calculated data type creates a field whose value is computed.

This question belongs to: Computer Microsoft Office

Question #3

In MS PowerPoint, which of the following is a type of slide transition effect?

A. Fade

B. All of the above

C. Push

D. Wipe

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Fade, Wipe, and Push are all transition effects available in PowerPoint.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs