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)

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

Quizplus · Accepted Answer

The AND function checks if all conditions are true. AND(C5:E5) checks if all values in cells C5, D5, and E5 are TRUE.

Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas