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 >=.

Practice

1. What does the AND function do in Excel?

easy

A. Returns TRUE if any one condition inside it is true.

B. Returns TRUE if all conditions inside it are true.

C. Returns the sum of all conditions.

D. Returns FALSE if all conditions are true.

Solution

1. Step 1: Understand the purpose of AND

   The AND function checks multiple conditions and returns TRUE only if every condition is true.

2. Step 2: Compare options with AND behavior

   Returns TRUE if all conditions inside it are true. correctly states that AND returns TRUE only if all conditions are true, which matches the function's behavior.

3. Final Answer:

   Returns TRUE if all conditions inside it are true. -> Option B

4. Quick Check:

   AND = TRUE if all true [OK]

Hint: AND needs all TRUE conditions to return TRUE [OK]

Common Mistakes:

• Thinking AND returns TRUE if any condition is true
• Confusing AND with OR function
• Assuming AND sums values

2. Which of these is the correct syntax for the AND function in Excel?

easy

A. AND(condition1; condition2)

B. AND[condition1, condition2]

C. AND{condition1, condition2}

D. AND(condition1, condition2)

Solution

1. Step 1: Recall Excel function syntax

   Excel functions use parentheses () and separate arguments with commas (,).

2. Step 2: Check each option's syntax

   AND(condition1, condition2) uses parentheses and commas correctly. The other options use incorrect separators or brackets.

3. Final Answer:

   AND(condition1, condition2) -> Option D

4. Quick Check:

   Correct syntax uses commas inside parentheses [OK]

Hint: Use commas inside parentheses for function arguments [OK]

Common Mistakes:

• Using semicolons instead of commas
• Using square or curly brackets
• Omitting parentheses

3. Given the values in cells: A1=5, B1=10, C1=5, what is the result of =AND(A1=5, B1>5, C1<10)?

medium

A. 5

B. FALSE

C. TRUE

D. Error

Solution

1. Step 1: Evaluate each condition

   A1=5 is TRUE (5 equals 5), B1>5 is TRUE (10 is greater than 5), C1<10 is TRUE (5 is less than 10).

2. Step 2: Apply AND logic

   Since all three conditions are TRUE, AND returns TRUE.

3. Final Answer:

   TRUE -> Option C

4. Quick Check:

   All conditions true = TRUE [OK]

Hint: Check each condition; all must be true for AND to return TRUE [OK]

Common Mistakes:

• Assuming AND returns FALSE if one condition is true
• Confusing comparison operators
• Ignoring cell values

4. Identify the error in this formula: =AND(A1=5 B1>3)

medium

A. Missing comma between conditions

B. Wrong comparison operator

C. Extra parentheses

D. AND function cannot compare numbers

Solution

1. Step 1: Review formula syntax

   The AND function requires commas to separate multiple conditions inside the parentheses.

2. Step 2: Identify the missing comma

   The formula lacks a comma between A1=5 and B1>3, causing a syntax error.

3. Final Answer:

   Missing comma between conditions -> Option A

4. Quick Check:

   Separate conditions with commas in AND [OK]

Hint: Separate conditions with commas inside AND [OK]

Common Mistakes:

• Forgetting commas between conditions
• Using semicolons instead of commas
• Misplacing parentheses

5. You want to check if a student passed both Math and English. Passing score is 50. Math score is in A2, English in B2. Which formula correctly returns TRUE only if both scores are 50 or more?

hard

A. =AND(A2>=50, B2>=50)

B. =AND(A2>50, B2>50)

C. =OR(A2>=50, B2>=50)

D. =AND(A2>50 B2>50)

Solution

1. Step 1: Understand the passing condition

   Passing means scores are 50 or more, so use >=50 for both subjects.

2. Step 2: Choose correct AND formula

   =AND(A2>=50, B2>=50) uses AND with >=50 for both A2 and B2, correctly checking both conditions. =AND(A2>50, B2>50) uses >50 which excludes 50 exactly. =OR(A2>=50, B2>=50) uses OR, which returns TRUE if only one subject passes. =AND(A2>50 B2>50) misses a comma, causing syntax error.

3. Final Answer:

   =AND(A2>=50, B2>=50) -> Option A

4. Quick Check:

   Use AND with >= for both scores [OK]

Hint: Use >= and commas inside AND for both conditions [OK]

Common Mistakes:

• Using > instead of >= excludes exact passing score
• Using OR instead of AND
• Missing commas between conditions