FormuladrillBest and worst month
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Find the highest monthly sales figure in D2 and the lowest in D3.
What this exercise teaches
MAX and MIN scan a whole range, so you never sort the list by hand.
A hint if you get stuck
Two different functions, one per cell. Both take the same range.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise