Case-Based Critical Thinking Questions Case 8-3 You Have Been Using

Multiple Choice

Case-Based Critical Thinking Questions Case 8-3 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