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