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

question 68

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

---

Definitions:

Stalagtite Formation

Structures that hang from the ceilings of caves, formed through the deposition of materials from water droplets containing minerals over thousands of years.

Paleography

The study of ancient and historical handwriting, including the analysis of scripts and the dating of manuscripts.

Radiocarbon Dating

A method of measuring the decay rate of carbon isotopes in organic matter to determine the age of organic materials such as wood and fiber.

Earliest-Known Sculptures

The oldest discovered artworks in the medium of sculpture, dating back to prehistoric times and serving various cultural and religious purposes.