Task 1 of 6
In G1, find the median of the average check (column B).
Lesson theory
A bakery chain compares its branches for the week. You'll practice MEDIAN, RANK, LARGE, SUMPRODUCT, and sorting.
Tip: the chain's average check is not the average of the averages. Calculate it as a weighted average: SUMPRODUCT(avg_check,checks)/SUM(checks).
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.