The AVERAGE Function

question 23

Multiple Choice

The AVERAGE function

• A) calculates the arithmetic mean of values in a range.
• B) identifies the midpoint value in a set of values.
• C) identifies the highest value in a range.
• D) displays the lowest value in a range.

---

Definitions:

Diverging Plates

Tectonic plates that are moving away from each other, often resulting in the formation of new crust as magma rises to fill the gap, seen at mid-ocean ridges and continental rift zones.

Converging Plates

The process where two tectonic plates move toward each other, often leading to mountain building, earthquakes, and volcanism.

Moving Away

The process of an object or entity increasing its distance from another point or object.

Mid-Ocean Ridge

An underwater mountain range formed by plate tectonics, where new oceanic crust is created by volcanic activity and then spreads away from the ridge.