Question: Excel formula: Write the formula with excel that assign the value Excellent to the cell C2 when the value of the cell B2 is

Excel formula: Write the formula with excel that assign the value

Excel formula: Write the formula with excel that assign the value " Excellent" to the cell C2 when the value of the cell B2 is greater or equal to 70, the value "Good" when the value of the cell B2 is greater or equal to 60 and "Satisfactory" when the value is greater than 40, and the value "Poor" in the other cases. (4 marks) Paragraph BIE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I would like to have answers of 18 to 51, in terms of excel formula. Question 2 Refer to Figure 1. Write the Excel formula for each cell marked with "?? in column C, and label each formula clearly...

BA 1605: Midterm Recap (Due: Feb. 27, 2015) Name _____________________________ 50 Student ID _____________________________ Section 01B 10:00~11:20 am Section 02B 01:00~02:20 pm [Questions 4 ~ 7] The...

i have posted first assignment then the preview steps. I would appreciate a detailed step by step explanation of each of the preview steps. your help is very much appreciated F2 General Merge &...

Please just write the formulas of the ones that require it! Thank you 1. Alex Makula is a project manager for the Content Shop, an online firm based in New Haven, Connecticut, that provides written...

Need help filling out the yellow blanks in excel!! Answers must be in excel formulas Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An...

Excel Chapter 7-Real Estate Exp19_Excel_Cho7_Cap_Real_Estate Project Description: You are the office manager for a real estate company in northern Utah County. You tracked real estate listings,...

Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. The...

Please help verify formulas are correct. Instructions in this link: C D E F H 1000 10 0.5 cities Austin Dallas-Forth Worth [ Houston G Shipping! 24 120 30 Date Arrived 44295 44301 44302 44298 44302...

YO19_Excel_Cho3_Prepare_Wedding Project Description: Clint Keller and Addison Ryan have just booked a wedding at Painted Paradise Resort and Spa When requested by a happy couple, the Turquoise Oasis...

1. 2. 3. 4. Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco....

What are the steps in the accounting cycle?

Compare the relative merits of targeting (a) The money supply; (b) The exchange rate; (c) The rate of inflation.

B&H Construction Company must choose between two types of cranes. Crane A costs $ 6 0 0 , 0 0 0 , will last for five years, and will require $ 6 0 , 0 0 0 in maintenance each year. Crane B costs $ 7...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...