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")
Answer: C
You might also like to view...
A(n) ________ is a note that can be added from the Review tab and is not generally printed
Fill in the blank(s) with correct word
A network technician is configuring a new firewall for placement into an existing network infrastructure. The existing network is connected to the Internet by a broadband connection. Which of the following represents the BEST location for the new firewall?
A. The firewall should be placed between the Internet connection and the local network. B. The firewall should be placed inside the local network. C. The firewall should be placed between the broadband connection and the Internet. D. The firewall should be placed in the Internet cloud.