The value in cell B2 cell is 65. In cell C2, the value is 75.

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?
Select one:
a. =NOT(OR(B2>=70, C2>=80))
b. =AND(B2>=70, C2>=80)
c. =IF(B2>=70, C2>=80)
d. =OR(B2>=70, C2>=80)
ANSWER: Option A is correct since, it turns to False if either B2 and/or C2 are false. The other options turn True when both are false.

Suppose the current price of a pound of steak is $6 per pound and the equilibrium price is $9 per pound.

Suppose the current price of a pound of steak is $6 per pound and the equilibrium price is $9 per pound. What takes place?

a. There is a shortage, so the price rises and the quantity demanded decreases.

b. There is a shortage, so the price rises and the quantity demanded increases.

c. There is a shortage, so the price falls and the quantity demanded increases.

d. There is a surplus, so the price falls and the quantity demanded increases.

 

Option a. There is a shortage, so the price rises and the quantity demanded decreases is correct

This option is correct because in the case of shortage there exists excess demand in the market such that the quantity demanded exceeds that the quantity supplied for a product. It means the price rises such that the quantity demanded falls in such a manner that the equilibrium is restored.