Case EX 5-2 Sam Is Using the Functions Within Excel

question 35

Multiple Choice

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?

• A) =AVG(E4,E9)
• B) =AVERAGE(E4:E9)
• C) =AVG(E4:E9)
• D) +AVERAGE(E4:E9)

---

Definitions:

Sucrose

Disaccharide composed of glucose and fructose; table sugar.

Salt

A mineral compound that is composed mainly of sodium chloride, which is essential for life in general.

Water

A tasteless, odorless, and colorless chemical substance composed of hydrogen and oxygen, essential for most forms of life on Earth.

Chemical Energy

The potential of a chemical substance to undergo a transformation through a chemical reaction to transform other chemical substances.