Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas

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