In Excel, what does the 'ROUND' function do? MCQ with Answer and Explanation

In Excel, what does the 'ROUND' function do?
A. Rounds up to the nearest integer
B. Rounds a number to a specified number of digits
C. Rounds to the nearest multiple
D. Rounds down to the nearest integer
Answer: Option B
Solution (By JKExamLibrary)
ROUND rounds a number to a specified number of decimal places. ROUNDUP rounds up, ROUNDDOWN rounds down, MROUND rounds to a multiple.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In PowerPoint, to insert a hyperlink, use the shortcut:
A. Ctrl + H
B. Ctrl + Shift + K
C. Ctrl + K
D. Ctrl + L

Correct Answer: Option C


Explanation:
Ctrl + K opens Insert Hyperlink dialog.

This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, which option is used to create a custom slideshow?
A. Slide Show > Custom Slide Show
B. Transitions > Custom Show
C. View > Custom Show
D. Design > Custom Show

Correct Answer: Option A


Explanation:
Custom Slide Show is under the Slide Show tab.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which option is used to change the page color?
A. Layout -> Page Background
B. Home -> Shading
C. Insert -> Background
D. Design -> Page Color

Correct Answer: Option D


Explanation:
Page Color is on the Design tab.

This question belongs to: Computer Microsoft Office