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

Question
What will be the output of the MS Excel formula =CEILING.MATH(22.1, 5)?
A. 25
B. 22
C. 20
D. 30
Answer: Option A
Solution (By JKSSB Mock Tests)
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
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
In PowerPoint, to apply the same transition to all slides, click:
A. Slide Master -> Transition
B. Copy transition and paste to all
C. Animation Painter
D. Apply To All in the Transitions tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Apply To All button sets the selected transition for every slide.
This question belongs to: Computer Microsoft Office
Question #2
Which of the following is the correct key to exit a submenu or cancel an operation in MS Office?
A. Esc
B. Alt
C. Shift + Tab
D. Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Esc cancels.
This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which feature automatically corrects common spelling and typing errors?
A. AutoFormat
B. AutoText
C. AutoCorrect
D. Spell Check
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AutoCorrect automatically fixes common mistakes, such as correcting 'teh' to 'the'. AutoText is for inserting predefined text, AutoFormat applies formatting, Spell Check checks manually.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?