Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas

question 33

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.
-Another way that Chloe could write the formula that would show if total purchases ever fell below $150,000 would be ____. The current value is $162,000.

• A) =B10<150
• B) =SUM(B10)<150
• C) =AND(B10)<150
• D) =B10>150

---

Definitions:

NWICO

An acronym for the New World Information and Communication Order, a movement promoting global equity in the dissemination and flow of information.

League of Nations

An intergovernmental organization founded in 1920 to promote world peace and cooperation, but was eventually replaced by the United Nations.

Dissemination of Information

The process of distributing knowledge or data to a wide audience through various means, including electronic and print media.

Propaganda

Information, especially of a biased or misleading nature, used to promote or publicize a particular political cause or point of view.