In Excel, which function rounds a number down to the nearest integer? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function rounds a number down to the nearest integer?

A. FLOOR()

B. All of these

C. ROUNDDOWN()

D. INT()

Answer: Option B

Solution (By JKSSB Mock Tests)

INT rounds down to integer. ROUNDDOWN to number of digits. FLOOR rounds down to multiple. All round down.

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 'Solver' add-in is used for:

A. Statistical analysis

B. Optimization and what-if analysis with multiple constraints

C. Solving equations

D. Goal seeking

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Solver finds optimal value for a target cell by changing multiple variables.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which of the following is used to add a footnote?

A. View > Footnote

B. Insert > Footnote

C. Review > Footnote

D. References > Insert Footnote

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Footnotes are inserted from the References tab.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following is not a valid way to start a new slide in MS PowerPoint?

A. Right-click in the slide pane and select New Slide

B. New Slide button on Home tab

C. Ctrl + N

D. Ctrl + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + N opens a new presentation, not a new slide. Ctrl + M inserts a new slide. The other options insert a new slide.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs