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. ROUNDDOWN()

C. ROUNDUP()

D. ROUND()

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

Share Report

In MS Word, which feature allows you to create a document by combining a main document with a data source?

A. Template

B. Macro

C. Mail Merge

D. Style

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Mail Merge is used to produce multiple documents from a single template and a data source, such as form letters, labels, and envelopes.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, the data type that can store files like Word documents or images within a record is:

A. Memo

B. Attachment

C. OLE Object

D. Hyperlink

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Attachment is the modern data type for storing multiple files. OLE Object is older but also stores objects; but Attachment is more versatile.

This question belongs to: Computer Microsoft Office