Which Formula Should Be Used to Determine the Net Flow

question 34

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:

Industrial Market

The market for goods, services, and supplies used in the production of other goods and services rather than for personal consumption.

Individual Quick Freeze

A food preservation process that rapidly freezes individual pieces of food, preserving freshness, texture, and flavor.

North American Industry Classification System

A classification system used by business and government to categorize and measure economic activity in the United States, Canada, and Mexico.

Six-Digit Coding

A detailed classification method, often referring to systems like the Harmonized System for classifying traded products, using six-digit codes to identify specific items.