MEDIAN Function - Free Excel Practice Online

This free, interactive exercise teaches you MEDIAN Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Statistical Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising MEDIAN Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this MEDIAN Function lesson

1. The MEDIAN function in excel returns the median, or middle value in a set of numbers. For example, =MEDIAN(B2:B4) would return 3.8 because if we put the numbers in order, 3.8 would be in the middle.Type =MEDIAN(B2:B4) to continue.
2. What would =MEDIAN(B2:B4) return?
3. If you pass an even number of numbers into the MEDIAN function, then there is no middle number and MEDIAN returns an average of the two middle numbers. What would =MEDIAN(B2:B5) return?
4. Write a formula to find the median household income.
5. What would =MEDIAN(B:B) return?
6. What would =MEDIAN(B:B) return?
7. What would =MEDIAN(B:B) return?
8. MEDIAN also accepts logical true/false statements as inputs, treating TRUE as 1 and FALSE as 0.What would =MEDIAN(TRUE, FALSE, TRUE) return?
9. What would =MEDIAN(TRUE, FALSE, TRUE, FALSE) return?
10. What would =MEDIAN(1=1, 1>1, 1>2) return?

MEDIAN Function practice - FAQ