Question $7$

$4\mathrm{.}22$ pts

JinGooLiMastoon company is a manufacturer of USB cables. The following table contains the sales volume of USB cables for different geographical regions in the last year. The sales manager of JinGooLiMastoon has asked you to report the total sales volume of only the regions with less than $1,000,0000$ sale units in the last year.

c$3$

Which of the following Excel formulas gives the answer to this question?

$=$ SUMIF$($C$3$:C$15,">1000")$

$=$AVERAGEIF$($C$3$:C$15,"<mn\; id="EditorElement\_2080855">1</mn><mn\; id="EditorElement\_2080856">0</mn><mn\; id="EditorElement\_2080857">0</mn><mn\; id="EditorElement\_2080858">0</mn><mi\; id="EditorElement\_2080859">"</mi><mi\; id="EditorElement\_2080860">)</mi>$