Which Excel Function Averages Cells in a Range Based on a Specified

question 13

Multiple Choice

Which Excel function averages cells in a range based on a specified condition?

• A) AVERAGEIF
• B) AVERAGE
• C) COUNTIF
• D) SUMIF

---

Definitions:

Glucose

Glucose is a simple sugar and a critical energy source for the cells in the body, playing a key role in metabolism and blood sugar regulation.

Major Nutrient

Essential substances required in large amounts for healthy growth, metabolism, and overall bodily function; includes carbohydrates, proteins, and fats.

Glucose

A fundamental sugar, essential for powering living creatures and forming part of various carbohydrates.

Plant Polysaccharide

Complex carbohydrates found in plants, consisting of long chains of monosaccharide units, and are important for energy storage and structural components.