To Use the SUBTOTAL Function to Calculate the Sum of Filtered

question 124

Multiple Choice

To use the SUBTOTAL function to calculate the sum of filtered table records, set the Function_Num argument to _____.

• A) 1 for AVERAGE
• B) 9 for SUM
• C) 2 for COUNT
• D) 10 for TOTAL

---

Definitions:

Ocean Currents

Large-scale movements of sea water driven by various factors such as wind, salinity, and temperature differences, affecting climate and marine life.

Warm Current

A movement of ocean water that carries heat from the tropics toward the poles, influencing regional climates and marine life patterns.

North Equatorial Current

The North Equatorial Current is a significant westward-flowing ocean current found in the Atlantic, Indian, and Pacific Oceans, positioned approximately at the latitude of the northern equator.

Cold Currents

Ocean currents that originate in polar regions and move towards the equator, affecting the climate and marine life of the areas they flow through.