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:

X-axis

The horizontal axis in a coordinate plane, often representing the independent variable in an equation.

Negative Relationship

A correlation where an increase in one variable leads to a decrease in another variable.

Vertical Axis

In a graph or chart, the vertical line or axis is typically used to represent the dependent variable or measure.

Horizontal Axis

In graphing, this is the x-axis, typically used to represent the independent variable or categories being compared.