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:

Arizona's Immigration Law

Refers to SB 1070, a 2010 Arizona statute that was the toughest anti-illegal immigration act in the United States at the time, requiring state law enforcement to enforce federal immigration laws.

Supreme Court

The highest judicial body in a country or state, often having the final authority in interpreting laws and the constitution.

Identity Papers

Official documents used to verify an individual's identity, such as passports, driver's licenses, and national ID cards.

Immigration Status

The legal position or condition of a person in regard to their right to enter or reside in a country.