Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas

question 140

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.
-Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula ____.

• A) =SUM(B5:B9)<150
• B) =AND(B5:B9)<150
• C) =SUM(B5:B9)<>150
• D) =AND(B5:B9)<=150

---

Definitions:

Forward Trade

A financial contract agreement to buy or sell assets at a specified future date and price, used primarily in commodity and currency markets.

Forward Exchange Rate

The agreed upon exchange rate for a currency pair to be traded at a future date, used in hedging and speculation.

Spot Exchange Rate

The current price for which one currency can be exchanged for another.

Foreign Exchange Market

A global marketplace for exchanging national currencies against one another.