In Excel, which function is used to calculate the median of a set of numbers? MCQ with Answer and Explanation

In Excel, which function is used to calculate the median of a set of numbers?
A. AVERAGE
B. PERCENTILE
C. MEDIAN
D. MODE
Answer: Option C
Solution (By JKExamLibrary)
MEDIAN returns the middle value.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
Which of the following features in MS PowerPoint lets you bundle multiple distinct design elements (shapes, images, text) into a single object container?
A. Selection Canvas
B. Merge Shapes
C. Group
D. SmartArt Layout

Correct Answer: Option C


Explanation:
Grouping (Ctrl + G) bundles multiple selected design assets together so they can be moved, scaled, or formatted as a single unit.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Word, which of the following is used to create a table of authorities?
A. Review > Table of Authorities
B. References > Table of Authorities
C. Insert > Table of Authorities
D. View > Table of Authorities

Correct Answer: Option B


Explanation:
Table of Authorities is in the References tab, used for legal citations.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Excel, what is the value returned if you run the formula =FLOOR.MATH(18.9, 5)?
A. 18
B. 19
C. 20
D. 15

Correct Answer: Option D


Explanation:
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