Which Formula Should Be Used to Determine the Net Flow

question 49

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)

Understand the principles of effective persuasion and influence in public relations.

Analyze the process and strategies for managing public perceptions and behaviors.

Grasp the significance of ethical considerations in public relations research.

Understand the role of theory in guiding public relations practices.

---

Definitions:

Glacier

A large mass of ice, formed from compacted layers of snow, that moves slowly over land.

Erosion

The process by which the surface of the Earth is worn away by the action of water, wind, or ice.

Terminal Moraine

Glacially carried sediment that accumulates at the terminus (end) of a glacier and a landform composed of such material; generally marks the glacier’s farthest downhill extent.

Recessional Moraine

A moraine that forms as the front of a glacier melts back and stagnates for some time in one location, depositing a pile of sediment.