What will be the output of the MS Excel formula =CEILING.MATH(22.1, 5)? MCQ with Answer and Explanation

What will be the output of the MS Excel formula =CEILING.MATH(22.1, 5)?
A. 30
B. 25
C. 22
D. 20
Answer: Option B
Solution (By JKExamLibrary)
The CEILING.MATH function rounds a specified number upward to the nearest integer multiple of significance. The nearest multiple of 5 greater than or equal to 22.1 is 25.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In Excel, the 'Go To Special' dialog can be opened by:
A. Ctrl + Shift + G
B. Ctrl + G
C. F5 -> Special button, or Home tab -> Find & Select -> Go To Special
D. Alt + F5

Correct Answer: Option C


Explanation:
F5 opens Go To, then click Special. Alternatively, Home > Find & Select > Go To Special.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which Access object is used to automate repetitive tasks without writing code?
A. Module
B. Report
C. Query
D. Macro

Correct Answer: Option D


Explanation:
Macros automate tasks via a simplified interface. Modules contain VBA code.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In PowerPoint, which option under File menu saves the presentation as a PDF?
A. Save As and choose PDF from type
B. Both A and B
C. Print to PDF
D. Export -> Create PDF/XPS Document

Correct Answer: Option B


Explanation:
Both Export and Save As allow saving as PDF.

This question belongs to: Computer Microsoft Office