Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas

question 84

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

---

Definitions:

Experience Of Emotion

involves the complex process of personally undergoing feelings, which is influenced by cognitive evaluations, physiological changes, and social-contextual factors.

Basic Emotions

Refers to a set of universally recognized primary emotions such as happiness, sadness, fear, disgust, surprise, and anger.

Psychologists

Professionals specializing in the science of behavior and mind, embracing all aspects of conscious and unconscious experience as well as thought.

Basic Emotions

Fundamental emotions that are hard-wired in humans since birth and universally recognized, including joy, surprise, sadness, anger, fear, and disgust.