Which Formula Should Be Used to Determine the Net Flow

question 64

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)SUMPRODUCTB6:B16,G6:G16)

---

Definitions:

Monocot

A group of flowering plants that are characterized by having a single seed leaf, or cotyledon, in addition to parallel leaf venation and scattered vascular bundles in stems.

Rhizoids

Thread-like structures that anchor nonvascular plants like mosses and liverworts to their substrates, but do not absorb nutrients like true roots.

Cotyledons

Embryonic leaf in seed-bearing plants, the first to appear from a germinating seed.

Ovule

In seed plants, a structure that contains the female gametophyte and has the potential to develop into a seed.