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:

ANOVA Table

A statistical table used to analyze the differences among group means in a sample.

Critical Value

A threshold in hypothesis testing that determines the boundary for rejecting the null hypothesis.

Normal Distributions

Probability distributions that are symmetrically bell-shaped, where data tends to cluster around a central mean value.

Equal Variances

A condition where two or more populations have the same variance.