MS Excel Question Answer

What will be the value of ceiling 977


= What will be the value of Ceiling (97,7)?

=Ceiling(97,7) की वैल्यू क्या होगी?
Topic : MS Excel

A. 98

B. 97

C. 91

D. None




Correct Answer

A. 98


Explanation :

 CEILING Function rounds a number up to the nearest multiple of Significance, regardless of sign of Significance

Syntax

CEILING(Number; Significance)

Number (required) is the number that is to be rounded up.

Significance (optional) is the number to whose multiple the value is to be rounded up.

Example

=CEILING(-11;-2) returns -10



CCC Practice Test Hindi Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Sarkari Exam Quiz O Level Online Test in Hindi Bank SSC Railway TET UPTET Question Bank