In Excel, to calculate the average of all the numeric data in cells B$2$ through B$10$ and obtain the answer in B$11,$ you would type the following formula in cell B$11$:

$=$Median$($B$2$:B$10)$

None will work

$=$Sum$($B$2$:B$10)/8$

$=$Average$($B$2$:B$10$