NOT function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to return TRUE if A1 is FALSE.

Excel

=NOT([1])

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

AA1

B1

CFALSE

DTRUE

Attempts:

3 left

💡 Hint

Common Mistakes

Putting TRUE or FALSE directly inside NOT instead of a cell reference.

Leaving the parentheses empty.

The NOT function reverses the logical value. Using A1 inside NOT returns TRUE if A1 is FALSE.

2fill in blank

medium

Complete the formula to return TRUE if B2 is NOT equal to 10.

Excel

=NOT(B2 [1] 10)

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

A>

B<

C=

D<>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' instead of '=' inside the formula.

Confusing greater than or less than operators.

The operator '=' checks for equality. NOT reverses the logical test, so NOT(B2=10) returns TRUE if B2 is not equal to 10.

3fill in blank

hard

Fix the error in the formula to correctly return TRUE if C3 is NOT TRUE.

Excel

=NOT([1])

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

AC3=TRUE

BTRUE

CNOT(C3)

DC3

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'C3=TRUE' inside NOT causes a logical test that returns TRUE or FALSE, but is redundant.

Nesting NOT inside NOT causes double negation.

NOT(C3) returns TRUE if C3 is FALSE. Writing C3 alone inside NOT is correct.

4fill in blank

hard

Fill both blanks to create a formula that returns TRUE if D4 is NOT blank.

Excel

=NOT(D4 [1] [2])

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

A=

B<>

C""

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' with 0 instead of empty quotes.

Forgetting to put quotes around the empty string.

The formula checks if D4 is not equal to an empty string "" (blank). NOT reverses it, so it returns TRUE if D4 is not blank.

5fill in blank

hard

Fill both blanks to create a formula that returns TRUE if E5 is NOT greater than 100.

Excel

=NOT(E5 [1] [2])

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

A>

B<=

C100

D50

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' inside the parentheses instead of '>'.

The formula inside NOT checks if E5 is greater than 100. NOT reverses it, so it returns TRUE if E5 is less than or equal to 100.

Practice

1. What does the Excel function NOT(TRUE) return?

easy

A. FALSE

B. TRUE

C. 0

D. 1

Solution

1. Step 1: Understand the NOT function behavior

   The NOT function reverses the logical value it receives. If the input is TRUE, it returns FALSE.

2. Step 2: Apply NOT to TRUE

   Applying NOT to TRUE gives FALSE.

3. Final Answer:

   FALSE -> Option A

4. Quick Check:

   NOT(TRUE) = FALSE [OK]

Hint: NOT flips TRUE to FALSE and vice versa [OK]

Common Mistakes:

• Thinking NOT(TRUE) returns TRUE
• Confusing TRUE/FALSE with 1/0
• Using NOT without parentheses

2. Which of the following is the correct syntax to use the NOT function in Excel?

easy

A. NOT(A1=10)

B. NOT A1=10

C. NOT(A1=10

D. NOT[A1=10]

Solution

1. Step 1: Recall Excel function syntax

   Excel functions require the function name followed by parentheses enclosing the argument.

2. Step 2: Check each option

   NOT(A1=10) uses correct syntax: NOT(A1=10). Options A, B, and D have missing or wrong parentheses or brackets.

3. Final Answer:

   NOT(A1=10) -> Option A

4. Quick Check:

   Correct syntax uses parentheses [OK]

Hint: Always use parentheses with Excel functions [OK]

Common Mistakes:

• Omitting parentheses
• Using square brackets instead of parentheses
• Placing NOT outside the parentheses incorrectly

3. Given cell A1 contains the value 5, what is the result of the formula =NOT(A1>10)?

medium

A. FALSE

B. TRUE

C. 5

D. 10

Solution

1. Step 1: Evaluate the condition inside NOT

   The condition A1>10 checks if 5 is greater than 10, which is FALSE.

2. Step 2: Apply NOT to the condition result

   NOT(FALSE) reverses FALSE to TRUE.

3. Final Answer:

   TRUE -> Option B

4. Quick Check:

   NOT(FALSE) = TRUE [OK]

Hint: Evaluate inside condition first, then flip with NOT [OK]

Common Mistakes:

• Assuming 5 > 10 is TRUE
• Forgetting NOT reverses the result
• Confusing cell value with formula result

4. The formula =NOT(A1=5 is entered in a cell. What is the issue with this formula?

medium

A. Incorrect use of NOT function

B. A1 cannot be compared to 5

C. Missing closing parenthesis

D. NOT function does not accept logical expressions

Solution

1. Step 1: Check formula syntax

   The formula has an opening parenthesis after NOT but no closing parenthesis.

2. Step 2: Identify the error

   Excel requires matching parentheses for functions. Missing closing parenthesis causes a syntax error.

3. Final Answer:

   Missing closing parenthesis -> Option C

4. Quick Check:

   All functions need matching parentheses [OK]

Hint: Count your parentheses carefully [OK]

Common Mistakes:

• Forgetting to close parentheses
• Misplacing parentheses around arguments
• Thinking NOT can't use logical tests

5. You want to highlight cells in column A that do NOT equal "Complete" using conditional formatting. Which formula should you use?

hard

A. =NOT("Complete"=A1

B. =NOT(A1=Complete)

C. =NOT(A1, "Complete")

D. =NOT(A1="Complete")

Solution

1. Step 1: Understand the condition to check

   You want to check if the cell text is NOT equal to "Complete".

2. Step 2: Write the correct NOT formula

   The correct syntax is NOT(A1="Complete") which returns TRUE when A1 is not "Complete".

3. Step 3: Check other options

   =NOT("Complete"=A1) misses closing parenthesis, causing syntax error. =NOT(A1=Complete) misses quotes around text, causing error. =NOT(A1, "Complete") uses wrong syntax with comma.

4. Final Answer:

   =NOT(A1="Complete") -> Option D

5. Quick Check:

   Use NOT with logical test inside parentheses [OK]

Hint: Put logical test inside NOT parentheses with quotes for text [OK]

Common Mistakes:

• Omitting quotes around text
• Using comma inside NOT
• Missing closing parenthesis