Solved

Nathan Is in Charge of Collections, and Is Putting Together

Question 97

Multiple Choice

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. -Instead of Call, Nathan has decided to list the due date for those customers who have a FALSE value in column C. Customers with a TRUE value in column C should still generate a Don't Call value. His formula now looks like ____. A) =IF(C5, Don't Call ,B5) B) =IF(C5,B5, Don't Call ) C) =AND(C5,B5, Don't Call ) D) =AND(C5, Don't Call ,B5)
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.
-Instead of "Call," Nathan has decided to list the due date for those customers who have a FALSE value in column C. Customers with a TRUE value in column C should still generate a "Don't Call" value. His formula now looks like ____.


A) =IF(C5,"Don't Call",B5)
B) =IF(C5,B5,"Don't Call")
C) =AND(C5,B5,"Don't Call")
D) =AND(C5,"Don't Call",B5)

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q92: If you are using a none of

Q93: Use the logical construct of OR(A1) to

Q94: An AND function returns a value of

Q95: The syntax of the NOT function evaluates

Q96: After establishing the conditional formatting in one

Q98: The term parent-child means that a function

Q99: In cases where you want to test

Q100: The formula =OR(K3:K21) returns a TRUE value

Q101: With conditional formatting, if both types of

Q102: In a decision tree, a logical test