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. All of these

B. FLOOR()

C. INT()

D. ROUNDDOWN()

Answer: Option A

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

Share Report

What does pressing the shortcut key combination Alt + Shift + D do in an active document workspace in MS Word?

A. Applies a double strikethrough effect

B. Inserts an automated, current system Date field

C. Opens the Font properties dialog box

D. Deletes the current paragraph block

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Alt + Shift + D instantly inserts a dynamic DATE field that reflects the current system date at the cursor position. Similarly, Alt + Shift + T inserts the current Time field.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, which of the following is used to create a user interface for data entry?

A. Form

B. Query

C. Report

D. Macro

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Forms are the primary interface for data entry and editing. Reports are for output, queries for data retrieval, macros for automation.

This question belongs to: Computer Microsoft Office