Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1 Write a subroutine (named TempTable) that takes the two temperatures in cells

ID: 3592595 • Letter: 1

Question

1 Write a subroutine (named TempTable) that takes the two temperatures in cells B7 and B8 in degrees Fahrenheit 2 and converts them to a range of x equally-spaced values in degrees Centigrade, where x is the number in cell B9 3 The conversion is °C - (F -32 ) * 5/9. 4 Display both the Fand C degrees in columns G and H beginning in row 8. 5 Add column headings 'Fahrenheit' and 'Centigrade' in row 7. This should work with any range of temperatures and any number of rows. |Begin Temp= 8 30 50 10 7 End Temp= 9 |Number ofrows = 10

Explanation / Answer

//Subroutine to convert farenhite to degree Celsius: