India Exam Junction
[Clerk (Morning) Dec, 2021]
19. The function, = CEILING(19283.123, 2), will give result of _________
19200
19283
19284
19283.12
Correct Answer :
19284
Solution
The CEILING function in Excel rounds a number up to the nearest multiple of the specified significance.
The formula =CEILING(19283.123, 2) will round 19283.123 up to the nearest multiple of 2. Since 19283.123 is closer to 19284 than 19282, it will round up to 19284.
Therefore, the correct answer is 19284.