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

Question Report Error

In Excel, which function returns the remainder after division?

A. QUOTIENT()

B. INT()

C. MOD()

D. ROUND()

Answer: Option C

Solution (By JKExamLibrary)

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

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, to insert an index, go to:

A. Layout -> Index

B. Review -> Index

C. References -> Insert Index

D. Insert -> Index

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Index is under References tab.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Access, the property 'Default Value' is used to:

A. Set the maximum length of a field

B. Format the display of data

C. Automatically enter a value when a new record is created

D. Restrict the type of data

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Default Value populates a field when a new record is added, unless overridden.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Access, which of the following is a valid data type for storing yes/no values?

A. Logical

B. Yes/No

C. All of the above

D. Boolean

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
The data type in Access is called 'Yes/No' (or sometimes 'Boolean' in other databases). Access uses Yes/No. So B is correct.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs