Case EX 4-2 Ben Is Copying Some Formulas and Wants

question 16

Multiple Choice

Case EX 4-2 Ben is copying some formulas and wants to make sure he has the cell references correct. Ben wants to copy a formula that is the sum of five rows. He wants the formula to change as he copies it so that it shows the sum of five rows for each column. What type of cell reference should Ben use?

• A) Absolute
• B) Relative
• C) Mixed
• D) None of the above

---

Definitions:

Bicarbonate

A negatively charged ion (HCO3-) that is a form of carbon dioxide in solution, playing a vital role in the buffering of blood pH.

Pancreas

The pancreas is an organ involved in digestion and blood sugar regulation, producing digestive enzymes and insulin, respectively.

Duodenum

The first section of the small intestine immediately beyond the stomach, where the majority of chemical digestion takes place.

Gallbladder

A small, pear-shaped organ located beneath the liver, which stores and concentrates bile, a digestive enzyme produced by the liver.