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. 20
B. 30
C. 25
D. 22
Answer: Option C
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 MS Access, the 'Validation Text' property is used to:
A. Define the input mask
B. Display a custom error message when the validation rule is violated
C. Set the default value
D. Format the field
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Validation Text provides a message.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function returns the number of days between two dates?
A. NETWORKDAYS()
B. DAYS()
C. Both A and C
D. DATEDIF()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DAYS(end, start) returns days. DATEDIF(start, end, "d") also returns days. NETWORKDAYS returns workdays.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, which function is used to calculate the correlation between two data sets?
A. All of the above
B. PEARSON
C. COVARIANCE
D. CORREL
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
CORREL and PEARSON compute correlation coefficient, and COVARIANCE computes covariance. All are related.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Abbreviations 369 Memory and Storage Devices 438 Computer Fundamentals 326 Programming Languages 0 Operating Systems 510
Explore Subjects
Maths 5575 English 15164 Science 4430 Static General Knowledge 6362 Economy GK 2220
Practice Mix
Milk and water are in ratio 4:6 in a 273 L mixture. Quantity of milk?
The blaze ______ they doused was huge.
The 'Rani of Jhansi' is associated with:
The posters were ________ all over the city.
The principal that gives Rs. 453600 interest in 8 years at 9% SI is