MIN and MAX functions in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Google Sheets

=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 semicolon instead of a colon for ranges.

Listing only two cells separated by a comma.

The MIN function needs a range like A1:A5 to find the smallest value in those cells.

2fill in blank

medium

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

Google Sheets

=MAX([1])

Drag options to blanks, or click blank then click option'

AB2:B6

BB2-B6

CB2;B6

DB2,B6

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash or semicolon instead of a colon for ranges.

Listing only two cells separated by a comma.

The MAX function requires a range like B2:B6 to find the largest value in those cells.

3fill in blank

hard

Fix the error in the formula to find the smallest number in cells C1 to C4.

Google Sheets

=MIN([1])

Drag options to blanks, or click blank then click option'

AC1,C4

BC1-C4

CC1;C4

DC1:C4

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash or semicolon instead of a colon.

Separating cells with a comma instead of a range.

The correct range uses a colon : between the first and last cell to include all cells in between.

4fill in blank

hard

Fill both blanks to create a formula that finds the largest number in cells D1 to D3 and E1 to E3.

Google Sheets

=MAX([1], [2])

Drag options to blanks, or click blank then click option'

AD1:D3

BD1-D3

CE1:E3

DE1;E3

Attempts:

3 left

💡 Hint

Common Mistakes

Using dashes or semicolons instead of colons for ranges.

Not separating the 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 smallest number among cells F1 to F4, G1 to G4, and the number 10.

Google Sheets

=MIN([1], [2], [3])

Drag options to blanks, or click blank then click option'

AF1:F4

BG1:G4

C10

DF1-F4

Attempts:

3 left

💡 Hint

Common Mistakes

Using dashes instead of colons for ranges.

Not including the number 10 as a separate argument.

The MIN function can take multiple ranges and numbers separated by commas. Use colons : for ranges and just write the number directly.