Which Excel formula is used to find the median of a dataset?

The formula used to find the median of a dataset in Excel is MEDIAN(). The median is the middle value in a set of numbers when they are arranged in ascending or descending order. If the dataset has an odd number of values, the median is simply the middle number. If it has an even number of values, the median is calculated by taking the average of the two middle numbers.

In contrast, the AVERAGE() function calculates the mean, which is the total of all the values divided by the number of values. MODE() refers to the most frequently occurring value in a dataset, while MEAN() is often used interchangeably with average in casual conversation but does not refer to a specific Excel function. Thus, for determining the median, using the MEDIAN() function is the appropriate choice.