Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas

Multiple Choice

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) )