BAN ASSIGNMENT 2 Excel Insert Draw Page Layout Formulas Data Review view StatToo
ID: 3250979 • Letter: B
Question
BAN ASSIGNMENT 2 Excel Insert Draw Page Layout Formulas Data Review view StatTools Q Tell me what you want to do Home E wrap Text B I U Format painter E Merge & center Conditional Format as cell G2 1 Company Name Company Type Executive Name Salary 2008 Bonus 2008 Total 2008 Recoded Company Type 3M ndustrials Buckley, George W. $1,720,000 $2,644,100 $4,364,1 3 Abbott Labs Health Care White, Miles D. $1,795,500 $4,200,000 $5,995,500 Advance Auto Parts Consumer Services Jackson, Darren R. $800,000 $1,959,900 $2,759,900 5 Advanced Micro Devices Technology Meyer, Derrick R. $856,700 $856,700 6 Aecom Technology ndustrials Dionisio, John M S956,500 S2,000,000 $2,956,500 7 AES. Utilities Hanrahan, Paul S999,000 $1.756,200 $2,755,200 8 Affiliated Computer ndustrials Blodgett, Ly $750,000 $725,600 $1,475,600 Aflac Financials $1,338,200 $0 $1,338,200 Amos, Daniel P. 10 AGCO ndustrials Richenhagen, Martin H. $1,024,800 $1,124,400 $2,149,200 $986,700 $1,305,600 $2,292,300 11 Agilent Technologies ndustrials Sullivan, William P. Financials Liddy, Edward M. 12 AIG $1,000,000 $2,002,000 $3,002,000 Basic Materials Jones, John P. 13 Air Products Basic Materials $1,400,000 $1,884,000 $3,284,000 Kleinfeld, Klaus 14 Alcoa asic Materials Hassey, L. Patrick $907,900 $2,149,900 $3,057,800 15 Allegheny Technologies 16 Allstate $1,040,800 $151,700 192,500 Wilson II, Thomas J. Financials $307,200 $307,200 Morris, Jeff D. Oil & Gas 17 Alon USA Energy Consumer Goods Szymanczyk, Michael E. $1,200,000 $2,800,000 $4,000,000 18 Altria Group Consumer Services Bezos, Jeffrey P. $81,800 19 Amazon.com $935,000 $771,700 $1,706,700 Rainwater, Gary L. Utilities Ameren $1,259,600 $1,654,100 S2,913,700 Morris, Michael G. Utilities 21 American Electric Power 1.250.000 Chenault, Kenneth $1.250.000 nancia 22 American Express 3.1 Pivot 4 3,1 Pivot 3 3.1 Pivot 2 3,1 Pivot 1 Case 3.1 3.23 Scatterplot 3.13 3.23 m a O here to searchExplanation / Answer
For cell G2 it would be ,
=IF(OR((B2="Telecommunications"),(B2="Technology")),"Tech/Telecomm",B2)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.