Question 1 of 10
| A | B | C | D | |
|---|---|---|---|---|
| 1 | -1 | |||
| 2 | 7 | |||
| 3 | 10 | |||
| 4 | 8 | |||
| 5 |
MIN, MAX, LARGE, SMALL Functions - Free Excel Practice Online
This free, interactive exercise teaches you MIN, MAX, LARGE, SMALL Functions 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 MIN, MAX, LARGE, SMALL Functions 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 MIN, MAX, LARGE, SMALL Functions lesson
- The MAX function returns the highest number from a list, and ignores text values. Write =MAX(A1:A4) to return the highest number (10).
- The MIN function obviously returns the minimum value. Write a MIN function on A1:A4 to get the smallest value (-1).
- The LARGE function returns the nth largest number, where n is the second argument. Write =LARGE(A1:A4, 3) to get the 3rd largest number (4).
- The SMALL function returns the nth smallest value from a list. Write a SMALL function to return the 2nd smallest value from A1:A4 (0).
- What would =LARGE(A1:B3, 2) return?
- Write a LARGE function on A1:A5 to return 6.
- Write a SMALL function on A1:A5 to return 6.
- Use the MAX function to return the highest value from the list.
- Write a function to get the 2nd smallest value from the list.
- Write a function to get the 3rd largest value from the list.
MIN, MAX, LARGE, SMALL Functions practice - FAQ
How do I practice MIN, MAX, LARGE, SMALL Functions in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the MIN, MAX, LARGE, SMALL Functions exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this MIN, MAX, LARGE, SMALL Functions lesson?
This lesson covers MIN, MAX, LARGE, SMALL Functions as part of the Statistical Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.