Sheetsdrill

Level 1: Basics Exercise 12 of 92

Cheapest and most expensive plan

A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Put the lowest monthly price in E1 and the highest in E2.

What this exercise teaches

MIN and MAX scan the range for you, so the answer stays right when a price changes or the list is reordered.

A hint if you get stuck

MIN and MAX each take the whole range of prices.

Functions used: MAX, MIN

Try it now, free, no account needed

Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Basics