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
Correct Answer:

Verified
Correct Answer:
Verified
Q28: The formula =OR(25<24,MIN(1,10)<2,3<=2+1) returns a _ value.<br>A)
Q29: In the formula =(1+2)/3<>10, Excel evaluates _
Q30: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING
Q31: Note that a(n) _ construct always has
Q32: You can apply conditional formatting to cells
Q34: If the conditions are not mutually exclusive,
Q35: Excel _ empty cells in a range
Q36: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING
Q37: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING
Q38: Relational expressions _.<br>A) are not case sensitive<br>B)