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

Question
In Excel, which function is used to calculate the median of a set of numbers?
A. PERCENTILE
B. MODE
C. MEDIAN
D. AVERAGE
Answer: Option C
Solution (By JKSSB Mock Tests)
MEDIAN returns the middle value.
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
Which of the following is the correct keyboard shortcut to open the 'Format Cells' dialog in Excel?
A. Both A and B
B. Ctrl + Shift + F
C. Ctrl + 2
D. Ctrl + 1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both open Format Cells, but Ctrl+1 opens main, Ctrl+Shift+F opens Font tab.
This question belongs to: Computer Microsoft Office
Question #2
What is the shortcut key used to display the traditional 'Save As' file dialog window directly in MS Word and Excel?
A. F12
B. Shift + F12
C. Ctrl + S
D. Alt + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The F12 function key opens the 'Save As' dialog box directly, allowing users to save files under alternative names, extensions, or file directories.
This question belongs to: Computer Microsoft Office
Question #3
Which feature in Excel restricts the type of data that can be entered into a cell?
A. Protect Sheet
B. Conditional Formatting
C. Goal Seek
D. Data Validation
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Data Validation controls allowed inputs (e.g., whole numbers, lists). Conditional Formatting changes appearance, Goal Seek performs what-if analysis, Protect Sheet restricts editing.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: