If Cell B7 Contains a Value That Is Greater Than

question 76

Multiple Choice

If cell B7 contains a value that is greater than 20,and "ORDER" will be displayed when the logical test is TRUE,which of the following contains the correct IF function syntax?

• A)=IF(B7<20, "ORDER", "OK")
• B)=IF(B7<20, "OK", "ORDER")
• C)=IF(B7>20, "ORDER", "OK")
• D)=IF(B7>20, "OK", "ORDER")

---

Definitions:

Protanopia

A form of color blindness where there is a deficiency in or absence of red cone photoreceptor cells, leading to difficulties distinguishing red and green hues.

Deuteranopia

A color vision deficiency where individuals cannot distinguish between red and green colors, a common type of red-green color blindness.

Rhodanopsia

A visual condition where there is a predominance of red in the visual field, often after looking at bright light.

Lateral Geniculate Cells

Neurons in the lateral geniculate nucleus, a part of the thalamus in the brain that processes visual information received from the retina.