Midwest Tornado Institute Joyce Bishop is a meteorologist at the Midwest Tornado Institute located in Decatur, Illinois. Joyce is preparing for a talk she is giving to a local civic group on the possible effects of global warming on tornados. She has collected data on minor, moderate, and major tornado sightings in fi ve-year periods during the second half of the twentieth century and wants you to create a graph for her talk showing her data. She’s already entered this data into an Excel workbook. Complete the following: 1. Open the Tornado workbook located in the Excel4\Case2 folder included with your Data Files, and then save the workbook as Tornado Sightings. In the Documentation sheet, enter your name in cell B3 and the date in cell B4. 2. In the Sightings History worksheet, select the range A3:E13, and then insert a 2-D clustered column chart. Move the embedded chart to a chart sheet named Sightings Chart. 3. Change the chart style to Style 32 (the last chart style in the fourth row of the Chart Styles gallery). 4. Insert the chart title Tornado Sightings: 1950–1999 at the top of the chart, and then change the font size to 24 points. 5. Add the vertical axis title Sightings in a 14-point font with horizontal orientation. Add the horizontal axis title Years in a 14-point font. 6. Move the legend to the bottom of the chart, and then set its font size to 14 points. 7. Change the line style of the horizontal gridline from a solid line to a dashed line. (Hint: Use the Dash type button in the Line Style options in the Format Major Gridlines dialog box.) 8. Add vertical gridlines to the major tick marks in the chart. Display the gridlines as dashed lines. 9. Change the chart type of the All data series from a column chart to a 2-D line chart. Change the color of the line to standard blue. 10. Select the plot area and change the fi ll to a picture fi ll, using the Cloud.jpg fi le located in the Excel4\Case2 folder included with your Data Files. (Hint: Open the Format Plot Area dialog box. In the Fill options, click the Picture or texture fi ll option button, click the File button, and then locate and select the picture fi le.)