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
Correct Answer:

Verified
Correct Answer:
Verified
Q23: The following formula is used to determine
Q24: The ORERROR function can determine if a
Q28: Lookup _ allow you to use tables
Q29: MATCHING<br>Identify the letter of the choice that
Q30: _ just above the header row of
Q31: MATCHING<br>Identify the letter of the choice that
Q32: The _ function calculates the number of
Q81: The _ function is a logical function
Q91: A(n)_ specifies the type of condition the
Q105: The _ function calculates the difference between