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:

Airports

Complexes that facilitate air transport, including runways, terminals, and support services for passengers and cargo.

Rail

A mode of transport that uses trains and railway tracks to move goods and passengers from one location to another.

Mumbai Dabbawalas

A renowned lunchbox delivery and return system in Mumbai, India, known for its efficiency and accuracy in delivering home-cooked food to office workers.

Train Station

A facility on a railway line where trains regularly stop to load or unload passengers and/or freight.