Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

17 JinGooLiMastoon company is a manufacturer of USB cables. The following table contains the sales volume of USB cables for different geographical regions in the

17 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 how many regions have had a sales volume of more than 1,000,000 units in the last year. C3 X fx B Sale per Region A 1 2 Region Product Model Sales Volume (000 units) 3 Malaysia USB Cable 1086 4 China USB Cable 642 5 France USB Cable 1391 6 Brazil 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 18 47 Which of the following Excel formulas gives the answer to this question? O AVERAGEIF(C3:C15,">1000") O=SUM(C3:C15) O AVERAGEIF(C3:C15," <1000") O=SUMIF(C3:C15,">1000") O AVERAGE(C3:C15) O=COUNTIF(C3:C15," <1000") O=COUNTIF(C3:C15,">1000") O=SUMIF(C3:C15," <1000") =COUNT(C3:C15)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Financial Reporting With Powerpivot

Authors: Florent Cailly, Thomas Brajcich

1st Edition

1517437563, 978-1517437565

More Books

Students also viewed these Accounting questions

Question

What is project portfolio management?

Answered: 1 week ago