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

What will be the output of the MS Excel formula =CEILING.MATH(14.2, 5)?
A. 15
B. 14
C. 20
D. 10
Answer: Option A
Solution (By JKSSB Mock Tests)
The CEILING.MATH function rounds a number up to the nearest specified multiple. The nearest multiple of 5 greater than or equal to 14.2 is 15.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
To close a presentation in PowerPoint, press:
A. Both A and B
B. Ctrl + W
C. Alt + F4
D. Ctrl + F4

Correct Answer: Option A


Explanation:
Ctrl+W or Ctrl+F4 closes the active presentation window. Alt+F4 exits PowerPoint.

This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, to apply a design theme, go to:
A. Insert -> Themes
B. Design -> Themes
C. Home -> Themes
D. View -> Themes

Correct Answer: Option B


Explanation:
Themes under Design tab.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, the 'Navigation Pane' can be used to:
A. Change document theme
B. Insert hyperlinks
C. Browse files
D. Search and navigate by headings, pages, and results

Correct Answer: Option D


Explanation:
Navigation Pane (Ctrl+F) shows headings and search.

This question belongs to: Computer Microsoft Office