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

Computer Science & Information Technology

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?

Computer Science & Information Technology

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

Computer Science & Information Technology

The Method attribute specifies the target destination for any response from a form.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The SmartArt graphic type that shows steps that repeat continuously is the ________

A) Relationship B) Process C) Cycle D) List

Computer Science & Information Technology