Give a business example where an IF function would be useful. How would using the AND or OR functions in the logical_test argument change the way the IF function works?
What will be an ideal response?
An IF function could be used to determine if inventories have fallen too low and need to be restocked. If the level of inventory is below a given level the IF function would return a recommendation to order more, otherwise it would recommend that no order be placed. Nesting the OR or AND functions in the IF function logical_test argument would allow for multiple criteria to be evaluated rather than a lone inventory value.
You might also like to view...
The OR condition:
A) displays records that meet all specified criteria. B) displays records that meet either of two criteria. C) can only be used in combination with the AND condition. D) cannot be used with filters.
What type of software runs virtual machines?
a. A hypervisor b. A digital simulator c. A virtual server d. A systems mirror
The pingutility uses Simple Network Management Protocol (SNMP) packets to query by IP address or by name.
Answer the following statement true (T) or false (F)
The physical ____________________ of a computer network indicates how the devices in the network are arranged.
Fill in the blank(s) with the appropriate word(s).