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: 75% (8 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...
-
A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term bond fund, and the third is a money market fund that provides a safe return of 8%. The...
-
What is the free-rider problem? Why does it discourage innovation in environmental protection and the adoption of high environmental standards? Can anything be done to overcome the free-rider problem?
-
1. Speculate as to the purpose of the share swap between BP and Rosneft. 2. What is the purpose of the two-year lockup period during which neither partner can sell its stock? How might the lockup...
-
Assume a venture has 3,500,000 common shares outstanding. One year later a Series A investor invests $1,300,000 in the venture with a post-money valuation of $9,500,000. Another year later a Series B...
-
Imagine that you are an investor on January 1, 2004, and using the historical data up to that date. Assume that the Global index cannot be included in your portfolio. a. Plot the efficient frontier...
-
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.
-
What is the difference between a culture that is tight and one that is loose?
-
Which firms are best in terms of integrating your account with your banking activities?
-
Radio frequency identification is used to a. keep track of the status and quantity of each inventory item. b. keep track of the customer base for a product in the store. c. stay in touch with other...
-
Describe when it might be appropriate to use each of the following pricing strategies: discounting, rebates, bundling, dynamic pricing, prestige pricing, psychological pricing, loss leader pricing,...
-
Based on what you know about the funds, which do you think would be best for your investment?
-
Which feature distinguishes a PERT chart from a Gantt chart? a. A PERT chart creates a time line of production tasks. b. A PERT chart creates a work flow for production equipment. c. A PERT chart...
-
A random sample of data was collected on residential sales in a large city. The accompanying table shows the selling price (Y, in $ 1,000s), area (X1, in hundreds of square feet), number of bedrooms...
-
The bookkeeper for Riley, Inc., made the following errors: a. A cash purchase of supplies of $357 was recorded as a debit to Supplies for $375 and a credit to Cash of $375. b. A cash sale of $3,154...
-
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.
-
. An OS Designer wants to have a paged memory management system with no more than a 10% increase in the memory access time. Given the main memory circle time of 800 ns and the cache access time is...
-
Purchased $ 2 3 , 6 5 0 of merchandise from Olympics gold invoice dated may 1 7
-
Calculate the following ratios for Walmart and a competitor for two years. Present your calculations in a table. Liquidity ratios: 1. Working Capital = Current Assets - Current Liabilities 2. Current...
Study smarter with the SolutionInn App