Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas

question 73

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)

---

Definitions:

Tympanic Membrane

A membrane forming part of the hearing system in the ear, functioning as the boundary between the external and middle ear.

Auricle

The outer part of the ear that collects sound waves; also known as the pinna.

Audiometer

An electronic device used to evaluate hearing loss by measuring a person’s ability to hear various sound frequencies.

Otoscope

A medical device used for examining the ear's interior to diagnose ear conditions and infections.