The file named Problem26data.xlsx contains sales data on the worlds 2,000 largest companies. If an integer between
Question:
The file named Problem26data.xlsx contains sales data on the world’s 2,000 largest companies. If an integer between 1 and 2000 is entered in cell B3, then cell C3 should return a sentence such as The company ranking #1 in revenue has revenue of $328.21. Use the TEXT function to ensure the dollar amount has the proper format.
Transcribed Image Text:
the Rank below Sentence Q D E Bank Company 1 ExxonMobil 2 Wal-Mart Stores 1 Royal Dutch/Shell Group 4 SP 5 General Motors 6 Chevron 7 Ford Motor 8 DaimlerChrysler Toyota Motor 10 ConocoPhillips 11 General Electric 12 Total 13 ING Group 14 Allianz Worldwide 15 Citigroup 16 AXA Group 17 Volkswagen Group 18 American Inti Group 19 Nippon Tel & Tel 20 Carrefour 21 M 22 Siemens Group 23 Generali Group 24 Hewlett-Packard 25 McKesson 26 Bank of America 27 Hitachi 28 ENI 29 Valero Energy 10 Home Depot 31 Fortis 32 Matsushita Electric Indi 11 Crdit Agricole M4 Honda Motor 35 Nivan Motor 36 JPMorgan Chase 37 Samsung Electronics 38 Deutsche Telekom 39 UBS 40 Cardinal Health 41 Metro Mi 42 SC Group 41 Berkshire Hathaway 44 Nestl 45 Aviva 46 Verizon Commun 47 Abold As IFIL China Pet & Chem (Sinopec 30 Altri Group 51 Credit Suisse Grous Country United States United States Netherlands United Kingdom United States United States United States Germany lapan United States United States France Netherlands Germany United States France Germany United States H Japan France United States Germany Italy United States United States United States Japan Raly United States United States Netherlands Japan France Japan Japan United States South Korea Germany Switzerland United States Germany United Kingdom United States Switzerland United Kingdom United States Netherlands Italy China United States Switzerland Industry Oil & Gas Operations Retailing Oil & Gas Operations Oil & Gas Operations Consumer Durables Oil & Gas Operations Consumer Durables Consumer Durables Consumer Durables Oil & Gas Operations Conglomerates Oil & Gas Operations Diversified Financials Insurance Banking Insurance Consumer Durables Insurance Telecommunications Services Food Markets Technology Hardware & Equipment Conglomerates Insurance Technology Hardware & Equipment Health Care Equipment & Services Banking Conglomerates Oil & Gas Operations Oil & Gas Operations Retailing Diversified Financials Consumer Durables Banking Consumer Durables Consumer Durables Banking Semiconductors Telecommunications Services Diversified Financials Health Care Equipment & Services food Markets Banking Diversified Financials Food, Drink & Tobacco Insurance Telecommunications Services Food Markets Diversified Financials Oil & Gas Operations Food, Drink & Tobacco Diversified Financials in cell 83 I will enter a number between 1 and 2000 Then C3 will yield a sentence ExxonMobil ranking 1 in revenue has revenue of 5328.21. Sales (bil) $328.21 $312.43 $306.73 $209.47 $192.60 $184.97 $178.10 $177.04 $171.00 $162.41 $149.70 $144.94 $137.11 $124.41 $120.12 $115.20 $112.61 $106.00 $100.87 $58.60 $91.11 $90.69 $88.95 $87.90 $85.88 $85.39 $84.22 $81.00 $82.36 $81.51 $1.48 $81.30 581.10 $80.71 $80.02 $79.90 $79.18 $78.53 $78.25 $77.85 $76.54 576.34 $26.31 $76.11 $75.61 $75.11 $70.56 $70.39 $70.37 $68.92 $68.31
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (7 reviews)
Answered By
Cyrus Sandoval
I a web and systems developer with a vast array of knowledge in many different front end and back end languages, responsive frameworks, databases, and best code practices. My objective is simply to be the best web developer that i can be and to contribute to the technology industry all that i know and i can do. My skills include:
- Front end languages: css, HTML, Javascript, XML
- Frameworks: Angular, Jquery, Bootstrap, Jasmine, Mocha
- Back End Languages: Java, Javascript, PHP,kotlin
- Databases: MySQL, PostegreSQL, Mongo, Cassandra
- Tools: Atom, Aptana, Eclipse, Android Studio, Notepad++, Netbeans.
Having a degree in Computer Science enabled me to deeply learn most of the things regarding programming, and i believe that my understanding of problem solving and complex algorithms are also skills that have and will continue to contribute to my overall success as a developer.
I’ve worked on countless freelance projects and have been involved with a handful of notable startups. Also while freelancing I was involved in doing other IT tasks requiring the use of computers from working with data, content creation and transcription.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
Exploratory Data Analysis (No Answer Version). Make sure that you have completed ALL the exercises related to the lecture. Read the materials on tables from the following link:...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
A New York Times editorial argued that college students are taken advantage of by credit card companies: The credit card industry has made a profitable art of corralling consumers into ruinous...
-
Select one of the following PCAOB Disciplinary Orders (available at www.pcaob.org). 1. ORDER INSTITUTING DISCIPLINARY PROCEEDINGS, MAKING FINDINGS, AND IMPOSING SANCTIONS In the Matter of Traci Jo...
-
The following income statement data for A T&T Inc. and Verizon Communications Inc. were taken from their recent annual reports (in millions): _____________________________ T&T _______________ Verizon...
-
Abbott Industries is a well-known supplier of pharmaceuticals worldwide. Founded by Dr. Wallace Abbott, the company was incorporated in 1900 after he had been developing and making pharmaceuticals...
-
Bo Vonderweidt, the production manager for Sportway Corporation, had requested to have lunch with the company president. Vonderweidt wanted to put forward his suggestion to add a new product line. As...
-
DATABASE SYSTEMS What is a key and how is it important in a relational model?
-
A network administrator has received reports of intermittent connectivity issues. To diagnose the problem, the network administrator has decided to use tcpdump. Which of the following are the primary...
-
Consider the following set of cash flows over a four-year period. Determine the NPV of these cash flows if r = 0.15 and cash flows occur at the end of the year. Year 1 2 3 4 Cash flow -$600 $550...
-
Each row of the file named Problem25data.xlsx contains between the hyphen and comma a QBs number of completions. Use text functions to extract each QBs number of completions.
-
1. Behavioral contingencydefine it and give an example. 2. Use some version of the verbal expression to be contingent in a way that shows you understand how to use the term correctly. For example,...
-
The assertion that is the highest risk for an auditor in auditing investments is: a. accuracy, valuation, and allocation. b. existence. c. completeness. d. presentation.
-
Describe the five-step process an auditor should apply when planning and performing an ADA.
-
What does the following say about economists' efforts to put value on nature? Discuss. Stewardship derives from value. The reason we have jewelry boxes is because diamonds are expensive. The value...
-
Unethical acts are generally committed by unethical people. What are some things companies can do to help ensure that their employees act ethically?
-
What are some reasons why the value of a business other than a small one is generally maximized when it is organized as a corporation?
-
A Walt Disney annual report contained the following note: The Company issued 100 billion (approximately $ 920 million) of Japanese yen bonds through a public offering in Japan. The bonds are senior,...
-
How has the globalization of firms affected the diversity of their employees? Why has increased diversity put an additional burden on accounting systems?
-
In what types of stores would you expect to find ( a ) convenience products, ( b ) shopping products, ( c ) specialty products, and ( d ) unsought products?
-
What kinds of consumer products are the following: ( a ) watches, ( b ) automobiles, and ( c ) toothpastes? Explain your reasoning.
-
Cite two examples of business products that require a substantial amount of service in order to be useful.
-
Try opening application data in TLS. It should be encrypted. You should not be seeing any readable data. Whereas Part 2 application data can be read in ASCII. Why?
-
What is the "disasters" associated with Enterprise Resource Planning (ERP) projects and deployments. What do these "disasters" have in common? What could have been done to salvage any of these...
-
Download and listen to the American Public Media Marketplace Tech Report from August 2, 2018 entitled "https://www.marketplace.org/2018/08/02/tech/security-fatigue-keeping-companies-being-secure" In...
Study smarter with the SolutionInn App