MIN and MAX functions in Excel - Interactive Code Practice

Practice - 5 Tasks

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.

The MIN function finds the smallest value in a range. Use a colon : to specify the range from A1 to A5.

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.

The MAX function returns the largest value in a range. Use a colon : to specify the range from B2 to B10.

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.

The formula needs a proper range with a colon :. Using a dash or comma causes errors or wrong results.

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.

The MAX function can take multiple ranges separated by commas. Use colons : to specify each range.

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.

The MIN function can take multiple arguments including ranges and numbers. Use colons : for ranges and just type the number directly.