Give the Logical Function for the Following: If Cell B7

question 2

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) =IFB7=12,ANDB10=10, "")YES)),7)
• B) =IFB10=10,ORB7=12,"")"YES")7)
• C) =IFB7=12,IFB10=10,"YES", "")),7)
• D) =IFB7=12,ANDB10=10,"YES","")B10="NO"),7)

---

Definitions:

Component

A part or element of a larger system that contributes to its functionality, such as hardware components in a computer or software components in an application.

IaaS

A type of cloud technology service that describes routers, switches, servers, virtual machines, load balancers, access points, storage, and any other infrastructure device that is provided through the online environment.

Disk Image Library

A collection or repository of disk images, which are exact copies of computer disks, used for backup, restoration, or emulation purposes.

Virtual Machines

Software emulations of physical computers that enable users to run multiple operating systems on a single physical hardware host.