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. MOD()

B. QUOTIENT()

C. ROUND()

D. INT()

Answer: Option A

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 MS PowerPoint, which feature is used to add a text placeholder that can be edited on the slide?

A. Shape

B. WordArt

C. Table

D. Text Box

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Text Box is a rectangular area where you can type and format text independently. WordArt is styled text, Shape can contain text, but Text Box is specifically for editable text.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which data type can store up to 1 GB of data for attachments?

A. Memo

B. Hyperlink

C. OLE Object

D. Attachment

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Attachment data type stores multiple files up to 2 GB total, but each file can be up to 256 MB, overall database limit. OLE Object also stores objects but is older.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, to freeze the top row so it remains visible while scrolling, go to:

A. View tab -> Freeze Panes -> Freeze Top Row

B. Page Layout -> Print Titles

C. Review tab -> Protect Sheet

D. Insert tab -> Header & Footer

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Freeze Panes under View tab can freeze rows/columns. Protect Sheet restricts editing.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs