Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company's customers. Please refer to the figure above as you answer the questions below.
-If any one value in column C, D, or E is FALSE, then that customer is going to be put on the Accounts Receivable Watch List. Chloe wants to return a value of TRUE for customers to be put on the watch list. She will write the formula for Aster Construction first, and then copy it to the other rows. The logical construct Chloe would use is ____.
A) OR(NOT(C5),NOT(D5),NOT(E5))
B) OR(C5:E5)
C) AND(C5:E5)
D) AND(NOT(C5),NOT(D5),NOT(E5))

Question

Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company's customers. Please refer to the figure above as you answer the questions below.
-If any one value in column C, D, or E is FALSE, then that customer is going to be put on the Accounts Receivable Watch List. Chloe wants to return a value of TRUE for customers to be put on the watch list. She will write the formula for Aster Construction first, and then copy it to the other rows. The logical construct Chloe would use is ____.
A) OR(NOT(C5),NOT(D5),NOT(E5)) 
B) OR(C5:E5) 
C) AND(C5:E5) 
D) AND(NOT(C5),NOT(D5),NOT(E5))

Quizplus · Accepted Answer

The formula for returning a value of TRUE for customers to be put on the watch list is OR(NOT(C5), NOT(D5), NOT(E5)). This checks if any one value in column C, D, or E is FALSE, and if so, returns TRUE. This formula should be copied to the other rows.

Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas