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:

Suggest

To propose or introduce an idea or plan for consideration or action.

Government Intervention

Actions taken by a government to influence or directly involve itself in the economy or specific sectors to achieve certain objectives.

Bargaining Process

The negotiation between employers and a group of employees aimed at reaching agreements to regulate working salaries, working conditions, and other aspects of workers' compensation and rights.

Provincial And National Levels

Pertains to the administrative divisions within a country, covering both the regions governed at an intermediate level (provincial) and the entire country (national).