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

Question

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

Quizplus · Accepted Answer

A lookup table would allow for a more efficient and organized approach to calculate costs in a spreadsheet, as it allows for quicker and easier lookup of values and eliminates the need for extensive nested IF functions.

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