Which of the Following Is an Example of a Conditional

question 36

Multiple Choice

Which of the following is an example of a conditional aggregate function?

• A)=IF(AND(C7>B3, D8<=5),"PAY","NO PAY")
• B)=IF(OR(C7>B3, D8<=5),"PAY","NO PAY")
• C)=IF(NOT(C7>B3),"PAY","NO PAY")
• D)=IF((SUM(A1:A7)>7),"PAY","NO PAY")

---

Definitions:

Transduction

A process by which sensory receptors change physical stimuli into signals that are eventually sent to the brain.

Thalamus

A crucial brain structure acting as a relay station for information between the cerebral cortex and the rest of the body.

Hypothalamus

A region of the brain that controls an immense number of bodily functions including emotions, autonomic functions, and hormone production.

Hippocampus

A major component of the brain involved in memory formation and spatial navigation.