Custom formula-based rules in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to allow only positive numbers in cell A1.

Google Sheets

=IF([1], TRUE, FALSE)

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

AA1>0

BA1>=0

CA1=0

DA1<0

Attempts:

3 left

💡 Hint

Common Mistakes

Using less than or equal to zero instead of greater than zero.

Checking for equality to zero instead of greater than zero.

The formula A1>0 checks if the value in cell A1 is greater than zero, allowing only positive numbers.

2fill in blank

medium

Complete the formula to allow only text entries in cell B2.

Google Sheets

=ISTEXT([1])

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

AC2

BA2

CB1

DB2

Attempts:

3 left

💡 Hint

Common Mistakes

Referencing the wrong cell.

Using a number instead of a cell reference.

The ISTEXT function checks if the content of cell B2 is text.

3fill in blank

hard

Fix the error in the formula to allow only dates after January 1, 2023 in cell C3.

Google Sheets

=C3>[1]

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

ADATE(2023,1,1)

B"2023-01-01"

C1/1/2023

D2023-01-01

Attempts:

3 left

💡 Hint

Common Mistakes

Using a string instead of the DATE function.

Writing the date as a division expression.

The DATE(2023,1,1) function correctly represents the date January 1, 2023 in Google Sheets formulas.

4fill in blank

hard

Fill both blanks to allow only whole numbers between 1 and 100 in cell D4.

Google Sheets

=AND(ISNUMBER(D4), D4 [1] 1, D4 [2] 100)

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

A>=

B<=

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using strict greater than or less than operators instead of inclusive ones.

Not checking if the value is a number.

The formula checks that D4 is a number, greater than or equal to 1, and less than or equal to 100.

5fill in blank

hard

Fill all three blanks to allow only text in cell E5 that starts with 'A' and has length 3.

Google Sheets

=AND(ISTEXT(E5), LEFT(E5, [1]) = [2], LEN(E5) [3] 3)

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

A1

B"A"

C=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using greater than instead of equals for length.

Not quoting the letter 'A' in the comparison.

The formula checks that E5 is text, starts with the letter 'A' (first character), and has length exactly 3.