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:

Cooperative Goals

Objectives that are designed to be achieved through collaboration and teamwork, often leading to mutual benefits.

Complex Environment

An environment characterized by various interconnected parts and variables, which can change unpredictably and affect outcomes significantly.

Nonroutine Tasks

Activities or jobs that require creativity, problem-solving, and are not performed in a regular, predictable manner.

Empowered Workforce

A group of employees who are given the authority and responsibility to make decisions and act autonomously.