Which Excel Function Totals Only the Cells in a Range

question 21

Multiple Choice

Which Excel function totals only the cells in a range that meet given criteria?

• A) COUNTIF
• B) CONCATENATE
• C) SUMIF
• D) TOTALNUM

---

Definitions:

Atm

A unit of pressure, also known as atmosphere, approximately equal to the earth's atmospheric pressure at sea level.

Temperature

A measure of the average kinetic energy of the particles in a system, signifying how hot or cold the system is.

°C

Degrees Celsius, a unit of temperature on the Celsius scale, where 0°C represents the freezing point of water, and 100°C its boiling point at sea level.

Atm

Standard atmosphere, a unit of pressure defined as 101,325 Pa; also used to denote the atmospheric pressure at sea level.