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:

Neutrophil

A type of white blood cell that forms an essential part of the immune system, primarily involved in fighting off infections by engulfing bacteria and debris.

Fibroblast

A type of cell found in connective tissue that produces collagen and other fibers.

Chondrocyte

A cell that has secreted the matrix of cartilage and become embedded in it; responsible for the maintenance and repair of cartilage tissue.

Red Blood Cell

A type of blood cell that is primarily responsible for carrying oxygen from the lungs to the rest of the body.