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

Question

Share Report Error

In Excel, which function is used to calculate the median of a set of numbers?

A. PERCENTILE

B. AVERAGE

C. MEDIAN

D. MODE

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

In PowerPoint, which shortcut key opens the 'Slide Show' tab?

A. Alt + W

B. Alt + S

C. Alt + H

D. Alt + D

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Alt+S for Slide Show tab.

This question belongs to: Computer Microsoft Office

Question #2

In Access, which of the following is a valid way to enforce referential integrity?

A. Cascade Update Related Fields

B. Cascade Delete Related Records

C. Neither

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
When defining a relationship, you can set referential integrity and optionally cascade update/delete. Both are options.

This question belongs to: Computer Microsoft Office

Question #3

In MS PowerPoint, which view allows you to see all the slides in a presentation as thumbnails arranged in horizontal rows for easy reordering?

A. Reading View

B. Slide Sorter View

C. Outline View

D. Presenter View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Sorter View displays all slides in the presentation as miniature thumbnails, allowing users to easily reorder, delete, or organize slides into sections.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs