Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below.
-Nathan wants to fill in the words "Call" and "Don't Call" on the spreadsheet based on the value in column C. He will list "Call" if the value is FALSE and "Don't Call" if the value is TRUE. What is the formula Nathan could write?
A) =IF(C5,"Don't Call","Call")
B) =IF(C5,"Call","Don't Call")
C) =AND(C5,"Don't Call","Call")
D) =AND(C5,"Call","Don't Call")

Question

Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below.
-Nathan wants to fill in the words "Call" and "Don't Call" on the spreadsheet based on the value in column C. He will list "Call" if the value is FALSE and "Don't Call" if the value is TRUE. What is the formula Nathan could write?
A) =IF(C5,"Don't Call","Call") 
B) =IF(C5,"Call","Don't Call") 
C) =AND(C5,"Don't Call","Call") 
D) =AND(C5,"Call","Don't Call")

Quizplus · Accepted Answer

The correct formula is =IF(C5,"Don't Call","Call") because the IF function checks if the condition (C5 is TRUE) is met; if TRUE, it returns "Don't Call", and if FALSE, it returns "Call".

Nathan Is in Charge of Collections, and Is Putting Together