Give the Logical Function for the Following: If Cell B7

question 32

Multiple Choice

Give the logical function for the following: If cell B7 equals 12, check contents of cell B10. If cell B10 is 10, then the value of the function in the string is YES; if not, it is a blank space. If cell B7 does not equal 12, then the value of the function is 7.

• A) =IF(B7=12,(AND(B10=10, "")(YES)),7)
• B) =IF(B10=10,(OR(B7=12,"")"YES")7)
• C) =IF(B7=12,(IF(B10=10,"YES", "")),7)
• D) =IF(B7=12,(AND(B10=10,"YES","")(B10="NO"),7)

---

Definitions:

Equilibrium Price

The price at which the quantity of a good demanded by consumers equals the quantity supplied by producers.

Milk

A nutritious white liquid food produced by the mammary glands of mammals, used as a primary source of nourishment for young mammals before they are able to digest other types of food.

Equilibrium Quantity

The quantity of goods or services supplied and demanded at the equilibrium price, where the quantity supplied equals the quantity demanded.

Equilibrium Price

The price at which the quantity of a good or service demanded by consumers equals the quantity supplied by producers, resulting in market balance.