Temp

The local university’s Meteorology department wants to use a worksheet to convert Fahrenheit temperatures to the equivalent Celsius temperatures. 

a) Create a new workbook. 

b) Enter the data and apply formatting as shown below.  In cell E3 enter the formula =5/9*(B3–32) to convert the Fahrenheit temperature stored in cell B3 to degrees Celsius:

c) Save the workbook naming it Temp Conversion. 

d) Format cell E3 to display 0 decimal places. 

e) Apply conditional formatting to cells B3 and E3 so that negative values will be displayed in a red font color. 

f) Enter the following Fahrenheit temperatures in cell B3, one at a time: 0, 32, and 80.  What Celsius temperature does each of these convert to? 

g) In row 5, have the worksheet convert temperatures from a Celsius temperature entered in cell B5 to a Fahrenheit temperature displayed in cell E5.  Use 26 for the Celsius tem- perature.  Include appropriate labels.  The formula needed for converting from degrees Celsius to Fahrenheit is =9/5*B5+32.  Display the result with 0 decimal places.  Change the column widths as necessary so that all the data is displayed entirely. 

h) Enter the following Celsius temperatures in cell B5, one at a time: 0, 12, and –21.  What Fahrenheit temperature does each of these convert to? 

i) In cell D1, add a link to a Web site, such as www.weather.com, where users could access current temperature data. 

j) Create a header that right aligns your name and a footer that center aligns the current date.  Add gridlines and row and column headings. 

k) Save the modified Temp Conversion and print a copy. 

l) Display the formulas in the cells instead of values.  Change the column widths as necessary so that the formulas are completely displayed.  Print a copy.