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:

Date and Time Stamp

A digital record that indicates the specific date and time at which an event occurred or a document was created, modified, or accessed.

EHR System

Electronic Health Records system, a digital version of a patient's paper chart, making health information more accessible and streamlining the care process.

Interoperability Standards

Agreed-upon protocols and guidelines that enable different information technology systems and software applications to communicate and exchange data efficiently.

National Alliance

A coalition or union formed between parties or groups at a national level, commonly for political, social, or economic purposes.