AND function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if both A1 and B1 are TRUE.

Excel

=AND([1])

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

AA1; B1

BA1 B1

CA1+B1

DA1, B1

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces or plus signs instead of commas between arguments.

Using semicolons which are not valid separators in Excel formulas.

The AND function requires arguments separated by commas. So A1, B1 is correct.

2fill in blank

medium

Complete the formula to check if A1 is greater than 10 and B1 is less than 5.

Excel

=AND(A1 > [1], B1 < 5)

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

A0

B10

C15

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong number in the comparison.

Confusing greater than and less than signs.

The condition is A1 greater than 10, so the correct number is 10.

3fill in blank

hard

Fix the error in the formula to check if C1 equals 5 and D1 equals 10.

Excel

=AND(C1 = 5 [1] D1 = 10)

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

A,

B+

C;

D&

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus signs or semicolons instead of commas.

Using ampersand which is for text concatenation.

The AND function arguments must be separated by commas, so , is correct.

4fill in blank

hard

Fill both blanks to check if E1 is not empty and F1 is greater than 0.

Excel

=AND(E1 [1] "", F1 [2] 0)

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

A<>

B>

C<

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using = instead of <> to check not empty.

Using < instead of > for greater than.

To check if E1 is not empty, use <> "". To check if F1 is greater than 0, use > 0.

5fill in blank

hard

Fill all three blanks to check if G1 is TRUE, H1 is FALSE, and I1 is greater than or equal to 100.

Excel

=AND(G1 = [1], H1 = [2], I1 [3] 100)

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

ATRUE

BFALSE

C>=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using text strings "TRUE" or "FALSE" instead of logical values.

Using < instead of >= for the last condition.

The formula checks if G1 is TRUE, H1 is FALSE, and I1 is greater than or equal to 100, so the blanks are TRUE, FALSE, and >=.