In MS Excel, what is the value returned if you run the formula =FLOOR.MATH(18.9, 5)? MCQ with Answer and Explanation

Question
In MS Excel, what is the value returned if you run the formula =FLOOR.MATH(18.9, 5)?
A. 15
B. 19
C. 18
D. 20
Answer: Option A
Solution (By JKSSB Mock Tests)
The FLOOR.MATH function rounds a specified number downward to the nearest integer multiple of significance. The nearest multiple of 5 below 18.9 is 15.
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 Word, which of the following is not a valid file format to save a document?
A. .docx
B. .xlsx
C. .txt
D. .pdf
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.xlsx is Excel format; Word cannot save as .xlsx directly.
This question belongs to: Computer Microsoft Office
Question #2
The shortcut to open the 'Page Setup' dialog in MS Excel is:
A. Alt + P, S, P (or Page Layout tab)
B. F12
C. Ctrl + P
D. Ctrl + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
No direct single shortcut; you can use Alt+P, S, P. Or from Page Layout tab. I'll ask: Which tab contains Page Setup group? Answer: Page Layout. So I'll adjust.
This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, to compress all images in a presentation to reduce file size, use:
A. File -> Compress Pictures (under Save As Tools) or Picture Format -> Compress Pictures
B. Design -> Compress Media
C. View -> Slide Master
D. Insert -> Picture -> Compress
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Compress Pictures option is available in Picture Format tab or via File > Save As > Tools.
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)?