Question 14 Jingoolimastoon Company Is A Manufacturer Of Usb Cables The Following Table Contains The Sales Volume Of Us 1 (27.68 KiB) Viewed 45 times
Question 14 Jingoolimastoon Company Is A Manufacturer Of Usb Cables The Following Table Contains The Sales Volume Of Us 2 (74.06 KiB) Viewed 45 times
QUESTION 14 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 average sales volume among all the regions in the last year. C3 IX ✓ fx А B 1 Sale per Region 2 Region Product Model Sales Volume 000 units) 3 Malaysia USB Cable 1086 4 China USB Cable 642 5 France USB Cable 1391 6 Brasil USB Cable 1900 7 US Northeast USB Cable 1547 8 US Southeast USB Cable 1384 9 US Midwest USB Cable 1344 10 US West USB Cable 1713 11 Iran USB Cable 1120 12 India USB Cable 300 13 Mexico USB Cable 1750 14 Canada USB Cable 901 15 Other USB Cable 1805 16 17 18
9 US Midwest 10 US West 11 Iran 12 India 13 Mexico 14 Canada 15 Other USB Cable USB Cable USB Cable USB Cable USB Cable USB Cable USB Cable 1344 1713 1120 300 1750 901 1805 16 17 18 Which of the following Excel formulas gives the answer to this question? O ESUMIF(C3:C15,">1000") O ECOUNT(C3:C15) O ESUMIF(C3:C15,"<1000") O=COUNTIF(C3:C15,"<1000") O=AVERAGE(C3:C15) O=AVERAGEIF(C3:C15,">1000") O =AVERAGEIF(C3:C15,"<1000") O=COUNTIF(C3:C15,">1000") O ESUM(C3:C15)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!