In Excel, which of the following functions rounds a number up, away from zero? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which of the following functions rounds a number up, away from zero?

A. CEILING()

B. ROUND()

C. ROUNDUP()

D. ROUNDDOWN()

Answer: Option C

Solution (By JKSSB Mock Tests)

ROUNDUP rounds up. CEILING also rounds up but to a specified multiple. ROUND rounds to nearest digit.

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 Access, which action query permanently deletes records from a table?

A. Update query

B. Append query

C. Delete query

D. Make-Table query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Delete query removes records. Update changes values, Append adds records to a table, Make-Table creates a new table.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which view is used to design the structure of a table (field names, data types)?

A. Form View

B. Design View

C. Datasheet View

D. Layout View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Design View is used to define field properties. Datasheet View shows data in rows/columns.

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut key to open the 'Open' dialog in MS Office?

A. Ctrl + S

B. Ctrl + N

C. Ctrl + O

D. Ctrl + P

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+O opens the Open dialog.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs