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:

Tooth Contact Pattern

The intermesh contact surfaces between a pair of mating gears; usually no-load tested using machinist’s (Prussian) blue or other semifluid test media.

Crown Gear

A large disc-shaped gear usually driven at right angles by a smaller pinion gear. It alters the torque path direction in a final drive carrier by 90 degrees, so that a longitudinal drive shaft can deliver transverse torque to the driving wheels.

Backlash

The gapping or play between mating gear teeth usually measured with thickness gauges or a dial indicator.

Fatigue-Type Failures

Failures in materials or components that occur due to repetitive stress or strain over time, leading to cracks or breaks.