Combining clauses in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to combine two conditions using AND.

Google Sheets

=AND(A1>10, [1])

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

AB1>5

BB1>=10

CB1=10

DB1<5

Attempts:

3 left

💡 Hint

Common Mistakes

Using less than instead of greater than.

Using equality instead of inequality.

The AND function requires both conditions to be true. Here, B1>5 is the correct second condition.

2fill in blank

medium

Complete the formula to combine two conditions using OR.

Google Sheets

=OR(A2=100, [1])

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

AB2<50

BB2>50

CB2=50

DB2>=100

Attempts:

3 left

💡 Hint

Common Mistakes

Using greater than or less than instead of equality.

Using a condition that is always false.

The OR function returns TRUE if either condition is true. Here, B2=50 is the correct second condition.

3fill in blank

hard

Fix the error in the formula combining conditions with AND.

Google Sheets

=AND(A3>0 [1] B3<10)

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

A&

B;

C+

D,

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolons or plus signs instead of commas.

Using ampersand which is for text concatenation.

The AND function requires conditions separated by commas. Using a comma is correct syntax.

4fill in blank

hard

Fill both blanks to combine conditions checking if A4 is positive and B4 is less than 20.

Google Sheets

=AND([1], [2])

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

AA4>0

BB4>20

CB4<20

DA4<0

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect inequality signs.

Mixing up greater than and less than.

The formula checks if A4 is greater than 0 and B4 is less than 20 using AND.

5fill in blank

hard

Fill all three blanks to create a formula that returns TRUE if C5 equals 10, or D5 is greater than 5, and E5 is less than 20.

Google Sheets

=AND(OR([1], [2]), [3])

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

AC5=10

BD5>5

CE5<20

DE5>20

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong comparison operators.

Placing conditions outside the correct functions.

The OR function checks if C5 equals 10 or D5 is greater than 5. The AND function then checks if that OR condition is true and if E5 is less than 20.