In Excel, what does the 'ROUND' function do? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the 'ROUND' function do?

A. Rounds up to the nearest integer

B. Rounds to the nearest multiple

C. Rounds down to the nearest integer

D. Rounds a number to a specified number of digits

Answer: Option D

Solution (By JKSSB Mock Tests)

ROUND rounds a number to a specified number of decimal places. ROUNDUP rounds up, ROUNDDOWN rounds down, MROUND rounds to a multiple.

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 file format is used for a macro-enabled Word document?

A. .docx

B. .docm

C. .doc

D. .dotm

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.docm is macro-enabled document. .docx without macros, .dotm macro-enabled template.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which of the following is an example of an action query?

A. Parameter query

B. Update query

C. Select query

D. Crosstab query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Action queries: Update, Delete, Append, Make-Table.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, which field property ensures that each record has a unique identifier?

A. Required

B. Validation Rule

C. Indexed

D. Primary Key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Primary Key uniquely identifies each record and does not allow nulls. Indexed improves search, Required forces data entry, Validation Rule checks input.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs