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

Question
In Excel, which function returns the remainder after division?
A. QUOTIENT()
B. ROUND()
C. INT()
D. MOD()
Answer: Option D
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
Which of the following is NOT a valid text wrapping option in MS Word?
A. Tight
B. Circular
C. Behind Text
D. Square
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Circular is not a wrapping style. Valid: In line with text, Square, Tight, Through, Top and Bottom, Behind Text, In Front of Text.
This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which key is used to extend a selection?
A. Ctrl
B. Shift
C. Alt
D. F8
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F8 turns on extend selection mode; pressing it repeatedly selects word, sentence, paragraph, etc. Shift+arrow also extends.
This question belongs to: Computer Microsoft Office
Question #3
In MS Word, what does the 'Gutter Margin' refer to?
A. The empty gap between two lines of text inside a paragraph
B. The footer section containing page counts and file metrics
C. Margin space added to the binding side of a document to prevent text coverage during binding
D. Margin space reserved on the right to accommodate comments
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A gutter margin adds extra buffer space to the side or top margin of a document intended for bookbinding, ensuring text remains fully legible.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: