Which Formula Should Be Used to Determine the Net Flow

question 8

Multiple Choice

Which formula should be used to determine the Net Flow values in cell K6 in the following spreadsheet model?

• A)SUMIF($C$6:$C$16,I6,$B$6:$B$16)-SUMIF($E$6:$E$16,I6,$B$6:$B$16)
• B)SUMIF($I$6:$I$12,B6,$B$6:$B$16)-SUMIF($I$6:$I$12,I6,$B$6:$B$16)
• C)SUMIF($E$6:$E$16,I6,$B$6:$B$16)-SUMIF($C$6:$C$16,I6,$B$6:$B$16)
• D)SUMPRODUCT(B6:B16,G6:G16)

---

Definitions:

Reproductive Disorders

Conditions that affect the reproductive system, potentially impacting fertility or leading to complications during pregnancy.

Wastewater Treatment

The process of removing contaminants from wastewater to make it safe for release into the environment or for reuse.

Toxic Metals

Toxic metals are elements like lead, mercury, arsenic, and cadmium that are poisonous even at low concentrations, posing serious health risks when they accumulate in the body.

Organic Pesticides

Pesticides derived from natural sources, used in agriculture to control pests without synthetic chemicals, aiming for environmental friendliness and sustainability.