Solved

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
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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions