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.
-Chloe also intends to send out a letter congratulating those customers who have the value TRUE in all three columns of C, D, and E. She now wants to write a formula to generate a TRUE value if a customer matches this criteria. The logical construct would be ____.

A) AND(C5:E5)
B) AND(C5:C9)
C) OR(C5:E5)
D) NOT(OR(C5:E5)