Bird
Raised Fist0
Excelspreadsheet~10 mins

MIN and MAX functions in Excel - Interactive Code Practice

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

Complete the formula to find the smallest number in cells A1 to A5.

Excel
=MIN([1])
Drag options to blanks, or click blank then click option'
AA1:A5
BA1-A5
CA1;A5
DA1,A5
Attempts:
3 left
💡 Hint
Common Mistakes
Using a dash or comma instead of a colon for ranges.
Typing cell references incorrectly.
2fill in blank
medium

Complete the formula to find the largest number in cells B2 to B10.

Excel
=MAX([1])
Drag options to blanks, or click blank then click option'
AB2-B10
BB2:B10
CB2,B10
DB2;B10
Attempts:
3 left
💡 Hint
Common Mistakes
Using a dash or comma instead of a colon for ranges.
Selecting only two cells instead of a range.
3fill in blank
hard

Fix the error in the formula to find the minimum value in cells C1 to C8.

Excel
=MIN([1])
Drag options to blanks, or click blank then click option'
AC1-C8
BC1;C8
CC1:C8
DC1,C8
Attempts:
3 left
💡 Hint
Common Mistakes
Using a dash or comma instead of a colon for ranges.
Using semicolons which are not valid for ranges.
4fill in blank
hard

Fill both blanks to create a formula that finds the maximum value between cells D3 to D7 and E3 to E7.

Excel
=MAX([1], [2])
Drag options to blanks, or click blank then click option'
AD3:D7
BD3-D7
CE3:E7
DE3;E7
Attempts:
3 left
💡 Hint
Common Mistakes
Using dashes or semicolons instead of colons for ranges.
Not separating ranges with a comma.
5fill in blank
hard

Fill all three blanks to create a formula that finds the minimum value among cells F1 to F5, G1 to G5, and the number 10.

Excel
=MIN([1], [2], [3])
Drag options to blanks, or click blank then click option'
AF1:F5
BG1:G5
C10
DF1-F5
Attempts:
3 left
💡 Hint
Common Mistakes
Using dashes instead of colons for ranges.
Putting numbers inside quotes or parentheses incorrectly.

Practice

(1/5)
1. What does the MIN function do in Excel?
easy
A. Finds the smallest number in a range of cells
B. Finds the largest number in a range of cells
C. Adds all numbers in a range of cells
D. Counts how many numbers are in a range of cells

Solution

  1. Step 1: Understand the purpose of MIN function

    The MIN function looks through a list of numbers and finds the smallest one.

  2. Step 2: Compare with other options

    MAX finds the largest, SUM adds numbers, COUNT counts numbers. Only MIN finds smallest.

  3. Final Answer:

    Finds the smallest number in a range of cells -> Option A

  4. Quick Check:

    MIN = smallest number [OK]
Hint: MIN always returns the smallest number in your selected cells [OK]
Common Mistakes:
  • Confusing MIN with MAX
  • Thinking MIN adds numbers
  • Using MIN to count cells
2. Which of these is the correct way to write a formula to find the maximum value in cells A1 to A5?
easy
A. =MAX(A1-A5)
B. =max(A1:A5)
C. =Max(A1;A5)
D. =max(A1,A5)

Solution

  1. Step 1: Check correct syntax for MAX function

    MAX function uses parentheses and a colon to specify a range: MAX(A1:A5).

  2. Step 2: Analyze each option

    =max(A1:A5) uses correct syntax. =MAX(A1-A5) uses minus sign, which is wrong. =Max(A1;A5) uses semicolon, which is invalid in Excel formulas. =max(A1,A5) only checks two cells, not the full range.

  3. Final Answer:

    =max(A1:A5) -> Option B

  4. Quick Check:

    MAX(range) uses colon for range [OK]
Hint: Use colon (:) to select a range inside MAX or MIN [OK]
Common Mistakes:
  • Using minus (-) instead of colon (:)
  • Using semicolon (;) instead of colon
  • Selecting only two cells instead of a range
3. Given the values in cells B1 to B5 as 10, 25, 7, 30, and 15 respectively, what will the formula =MIN(B1:B5) return?
medium
A. 7
B. 10
C. 15
D. 30

Solution

  1. Step 1: Identify the values in the range B1:B5

    The values are 10, 25, 7, 30, and 15.

  2. Step 2: Find the smallest number among these values

    The smallest number is 7.

  3. Final Answer:

    7 -> Option A

  4. Quick Check:

    MIN(10,25,7,30,15) = 7 [OK]
Hint: MIN returns the smallest number in the selected cells [OK]
Common Mistakes:
  • Choosing the first number instead of the smallest
  • Confusing MIN with MAX
  • Selecting a number outside the range
4. You wrote the formula =MAX(A1:A4, A5:A8) but Excel shows an error. What is the problem and how to fix it?
medium
A. MAX cannot take multiple ranges; combine ranges with a comma
B. MAX can take multiple ranges but they must be separated by semicolons, so use semicolons
C. MAX can take multiple ranges but they must be separated by commas, so formula is correct
D. MAX can take multiple ranges separated by commas, but ranges must be enclosed in parentheses separately

Solution

  1. Step 1: Understand MAX function syntax for multiple ranges

    MAX can accept multiple ranges separated by commas, like MAX(A1:A4, A5:A8).

  2. Step 2: Check why error might occur

    If error occurs, it might be due to regional settings using semicolons instead of commas. But standard Excel uses commas.

  3. Final Answer:

    MAX can take multiple ranges but they must be separated by commas, so formula is correct -> Option C

  4. Quick Check:

    MAX(range1, range2) works with commas [OK]
Hint: Separate multiple ranges with commas inside MAX [OK]
Common Mistakes:
  • Using semicolons instead of commas
  • Trying to add ranges with plus signs
  • Not enclosing ranges properly
5. You have sales data in cells C2 to C10. You want to find the difference between the highest and lowest sales values. Which formula will give you the correct result?
hard
A. =MAX(C2:C10) * MIN(C2:C10)
B. =MIN(C2:C10) - MAX(C2:C10)
C. =MAX(C2:C10) + MIN(C2:C10)
D. =MAX(C2:C10) - MIN(C2:C10)

Solution

  1. Step 1: Understand the goal

    You want the difference between the highest and lowest sales values, so subtract the smallest from the largest.

  2. Step 2: Analyze each formula

    =MAX(C2:C10) - MIN(C2:C10) subtracts MIN from MAX, which is correct. =MIN(C2:C10) - MAX(C2:C10) subtracts MAX from MIN, which gives a negative or wrong result. Options A and C multiply or add, which are not differences.

  3. Final Answer:

    =MAX(C2:C10) - MIN(C2:C10) -> Option D

  4. Quick Check:

    Difference = largest - smallest [OK]
Hint: Subtract MIN from MAX to get range difference [OK]
Common Mistakes:
  • Subtracting MAX from MIN
  • Adding instead of subtracting
  • Multiplying values instead of subtracting