AVERAGE adds everything and divides, so one huge value pulls it up. MEDIAN returns the middle value of the sorted list instead: half the values are below it, half above. That's why salaries and house prices are usually reported as medians. With an even number of values, MEDIAN averages the middle two.
MODE.SNGL (or the older MODE) returns the most common value: the shoe size that sells most, the most frequent order quantity. If no value repeats, it shows #N/A, so wrap it in IFERROR when that can happen. With a tie, it returns the one that appears first.
All three skip text and blanks.