What Does the Excel "=SUMPRODUCT(A1:A5,C6;C10)" Function Do

question 12

Multiple Choice

What does the Excel "=SUMPRODUCT(A1:A5,C6;C10) " function do?

• A) Sums each range and multiplies the sums.
• B) Sum each pair of cells and multiples each sum.
• C) Multiplies the contents of cells containing the =SUM() command.
• D) Multiplies each pair of cells in two arrays matched by position and sums the products.

---

Definitions:

Continuous Positive Airway Pressure (CPAP)

Ventilatory support used to treat patients with obstructive sleep apnea, patients with congestive heart failure, and preterm infants with underdeveloped lungs.

Pneumothorax

Collection of air or gas in the pleural space.

Chest Tube Insertion

A medical procedure that involves the placement of a tube into the chest to remove air, fluid, or pus from the pleural space.

Suction Control Chamber

A component of a chest drainage system that regulates the pressure and amount of suction applied.