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...
Give an example execution of the ring-based algorithm to show that processes are not necessarily granted entry to the critical section in happened-before order.
What will be an ideal response?
You need to enable Client Hyper-V on a virtual machine; what feature do you need to use?
A. tunneling protocol B. live migration C. nested virtualization D. Hyper-V replica
The Method attribute specifies the target destination for any response from a form.
Answer the following statement true (T) or false (F)
The SmartArt graphic type that shows steps that repeat continuously is the ________
A) Relationship B) Process C) Cycle D) List