---
title: "MIN, MAX and LARGE practice: 4 exercises with answers"
description: "Practice MIN, MAX and LARGE in Excel: the fastest time, the best month, the runner-up and the spread, checked in a live spreadsheet."
canonical_url: "https://excelsavvy.com/practice/minmax"
meta:
  "og:description": "Practice MIN, MAX and LARGE in Excel: the fastest time, the best month, the runner-up and the spread, checked in a live spreadsheet."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TUlOLCBNQVggYW5kIExBUkdFIHByYWN0aWNlOiA0IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgTUlOLCBNQVggYW5kIExBUkdFIGluIEV4Y2VsOiB0aGUgZmFzdGVzdCB0aW1lLCB0aGUgYmVzdCBtb250aCwgdGhlIHJ1bm5lci11cCBhbmQgdGhlIHNwcmVhZCwgY2hlY2tlZCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiUnVubmVyIiwiU2Vjb25kcyJdfSx7Im4iOjIsImNlbGxzIjpbIklkYSIsIjEyLjQiXX0seyJuIjozLCJjZWxscyI6WyJKb24iLCIxMS44Il19LHsibiI6NCwiY2VsbHMiOlsiS2ltIiwiMTMuMSJdfSx7Im4iOjUsImNlbGxzIjpbIkxlYSIsIjExLjUiXX0seyJuIjo4LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9taW5tYXgi%2Cs_8mATlU-EFnu_s8fB.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "MIN, MAX and LARGE practice: 4 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TUlOLCBNQVggYW5kIExBUkdFIHByYWN0aWNlOiA0IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgTUlOLCBNQVggYW5kIExBUkdFIGluIEV4Y2VsOiB0aGUgZmFzdGVzdCB0aW1lLCB0aGUgYmVzdCBtb250aCwgdGhlIHJ1bm5lci11cCBhbmQgdGhlIHNwcmVhZCwgY2hlY2tlZCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiUnVubmVyIiwiU2Vjb25kcyJdfSx7Im4iOjIsImNlbGxzIjpbIklkYSIsIjEyLjQiXX0seyJuIjozLCJjZWxscyI6WyJKb24iLCIxMS44Il19LHsibiI6NCwiY2VsbHMiOlsiS2ltIiwiMTMuMSJdfSx7Im4iOjUsImNlbGxzIjpbIkxlYSIsIjExLjUiXX0seyJuIjo4LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9taW5tYXgi%2Cs_8mATlU-EFnu_s8fB.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **MIN, MAX and LARGE practice exercises**

Find the smallest and largest values in a range, and the second or third largest with LARGE.

[**Start the first exercise**](https://excelsavvy.com/practice/minmax/min-function)

LARGE(MAX(MIN(

## **How MIN, MAX and LARGE work**

MIN returns the smallest number in a range and MAX returns the largest. LARGE takes a second argument, k, and returns the k-th largest, so LARGE with 2 gives you the runner-up. All three skip text and empty cells.

For 100 m times in B2:B7, `**=MIN(B2:B7)**` gives the fastest time. For monthly sales in B2:B6, `**=MAX(B2:B6)**` gives the best month. `**=LARGE(B2:B7,2)**` returns the second-highest score. To measure how far apart the highest and lowest values are, subtract one from the other: `**=MAX(B2:B6)-MIN(B2:B6)**`.

These functions return the value, not the name that goes with it, so you still need a lookup to find out who ran the fastest time. If the range holds no numbers, MIN and MAX return 0, which can look like a real result. LARGE returns #NUM! when k is larger than the number of values. For the smallest values, SMALL works like LARGE. The exercises below cover MIN, MAX, LARGE and the spread between highest and lowest.

1. [**1****Find the fastest time with MIN**In B8, use MIN to find the fastest (lowest) 100 m time in B2:B7.](https://excelsavvy.com/practice/minmax/min-function)
2. [**2****Find the best month with MAX****Premium**In E2, use MAX to find the highest sales figure in B2:B6.](https://excelsavvy.com/practice/minmax/max-function)
3. [**3****Find the runner-up with LARGE****Premium**In E2, use LARGE to find the second-highest score in B2:B7.](https://excelsavvy.com/practice/minmax/large-second-highest)
4. [**4****The spread between highest and lowest****Premium**In E1, work out how far apart the quotes are, the highest minus the lowest. Subtract MIN from MAX in one formula.](https://excelsavvy.com/practice/minmax/max-minus-min-spread)

## **Functions in this topic**

- [**LARGE**](https://excelsavvy.com/functions/large)
- [**MAX**](https://excelsavvy.com/functions/max)
- [**MIN**](https://excelsavvy.com/functions/min)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**Excel finance data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-finance-practice-data)

## **Questions**

<details>

<summary>

### How do I find the name that goes with the highest value?

</summary>

Combine MAX with INDEX and MATCH: =INDEX(A2:A7,MATCH(MAX(B2:B7),B2:B7,0)) finds the highest number in B2:B7 and returns the name from the same row in column A. If two rows tie for the highest value, you get the first one.

</details>

<details>

<summary>

### Why does MAX or MIN return 0?

</summary>

The range has no numbers in it, so Excel falls back to 0. This happens when the cells are empty, hold only text, or hold numbers stored as text. Convert the text to numbers and the real maximum or minimum shows up. Make sure the range also points at the right cells.

</details>

<details>

<summary>

### How do I find the second-lowest value in Excel?

</summary>

Use SMALL, the mirror image of LARGE: =SMALL(B2:B7,2) returns the second-smallest number in B2:B7. Change 2 to 3 for the third-smallest, and so on. SMALL with 1 gives the same answer as MIN, and like LARGE it skips text and empty cells.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/minmax#webpage","description":"Practice MIN, MAX and LARGE in Excel: the fastest time, the best month, the runner-up and the spread, checked in a live spreadsheet.","name":"MIN, MAX and LARGE practice: 4 exercises with answers","url":"https://excelsavvy.com/practice/minmax","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/minmax#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/minmax#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/minmax#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/minmax#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/minmax"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/minmax#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"MIN, MAX and LARGE practice: 4 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/minmax#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I find the name that goes with the highest value?","acceptedAnswer":{"@type":"Answer","text":"Combine MAX with INDEX and MATCH: =INDEX(A2:A7,MATCH(MAX(B2:B7),B2:B7,0)) finds the highest number in B2:B7 and returns the name from the same row in column A. If two rows tie for the highest value, you get the first one."}},{"@id":"https://excelsavvy.com/practice/minmax#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does MAX or MIN return 0?","acceptedAnswer":{"@type":"Answer","text":"The range has no numbers in it, so Excel falls back to 0. This happens when the cells are empty, hold only text, or hold numbers stored as text. Convert the text to numbers and the real maximum or minimum shows up. Make sure the range also points at the right cells."}},{"@id":"https://excelsavvy.com/practice/minmax#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I find the second-lowest value in Excel?","acceptedAnswer":{"@type":"Answer","text":"Use SMALL, the mirror image of LARGE: =SMALL(B2:B7,2) returns the second-smallest number in B2:B7. Change 2 to 3 for the third-smallest, and so on. SMALL with 1 gives the same answer as MIN, and like LARGE it skips text and empty cells."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
