You Have Been Using a Variety of Nested IF Functions

question 27

Multiple Choice

You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use.
-Which of the following is an effective alternative for the use of extensive nested IF functions?

• A)compare table
• B)function table
• C)lookup table
• D)case table

---

Definitions:

Hypothetical Syllogism

A logical argument composed of two conditional statements and a conclusion, based upon hypothetical scenarios.

Denying

The act of declaring something to be untrue or rejecting the validity of a claim.

Antecedent

An event, condition, or cause that logically or necessarily precedes another.

Standard Form

A commonly accepted or prescribed format for presenting an argument, document, or mathematical expression.