Excel+Excercise

A clam farmer has been keeping records concerning the water temperature and the number of cl ams developing from fertilized eggs. The data is provided below: 15, 20, 25, 30, 35, 40, 45, 50    75, 90, 120, 140, 75, 40, 15, 0     From looking at the chart:
 * 1)  Open a new workbook in Microsoft Excel. What is the name of your new document right now? **Book1**
 * 2)  Save your workbook on your home drive. What did you name it? **Tech**
 * 3)  Down at the bottom of the workbook are 3 tabs named Sheet 1, Sheet 2, Sheet 3. D  elete Sheets 2 and 3. Rename Sheet 1: Water Temp Data.
 * 4)  Move your cursor to cell A1. How do you know it’s A1? It **says A1 in the corner**
 * 5)  Here is the problem you will enter data for and chart:
 * 1)  In A1, type the following title: Water Temperature in °  C
 * 2)  In B1, type the following title: Number of Developing Clams
 * 3)  Format the titles so that they are font size 12 and BOLD. What happens to  the text? **It becomes bold and bigger**
 * 4)  Make an adjustment to the columns to make the text fit. How did you do it? **I put my mouse on vertical column A and B and stretched them to fit the text**
 * 5)  Enter the following numbers in column A, beginning in cell A2:
 * 1)  Enter the following numbers in column B, beginning in cell B2:
 * 1)  Make sure NOT to label the numbers when you enter them into the cells. Why? **They are labeled in the title**
 * 2)  Center the data in both columns.
 * 3)  Highlight all the data and the titles you have entered. How can you tell it’s highlighted? Where is the beginning of the highligh  t? How do you know? **It is light blue where I highlighted with a black outline. The beginning of the highlight is around the block you started on.**
 * 4)  Create  a Chart using the Chart Wizard:
 * 5)  The Chart Wizard is included in Excel to help you choose the type of chart you want to make and let you specify chart options.
 * 6)  You could also use the Insert menu and se  lect Chart.
 * 7) The first box of the Chart Wizard asks you to choose a Chart Type and Sub-Type. You need a line graph, but NOT the line graph in the list. **Do you know why? They cross over each other**
 * 8)  Choose XY (Scatter) and choose one to the sub-types with lines. Note the XY. What shou  ld that remind you of? **a coordinate plane**
 * 9) Click Next.
 * 10) The second box of the Chart Wizard is looking for the data range. You can make the box smaller by clicking on the button on the far right of the data range box. The data range will become a small box at the top of the screen and you’ll be able to select the cells you want to include in the data range. Once you submit the data range, you return to the Chart Wizard and the source data box will appear. *Use this if you forgot to highlight the range of data to be charted. If you selected your data as instructed, this box shows a preview of the chart with data range you have selected.
 * 11)  Click Next
 * 1) The third box of the Chart Wizard asks you to specify the chart options. Click on the tabs across the top of the box to change options. For example: to change the options for the Legend. Click the legend tab.
 * 2)  The fourth box allows you to place the chart either in the data excel worksheet or on a new sheet. Most of the time you will select a new sheet.
 * 3)  Click on the Finish bu  tton to create the chart
 * 1)  What is the dependent variable? How do you know? **Number of developing clams it is on the Y axis.**
 * 2)  What is the independent variable? How do you know? **Water temp in °C it is on the X axis**
 * 3)  What is the optimum temperature for clam development? Why? **30 °C because it has the highest number of clams**
 * 4)  How does this chart compare with the one y  ou drew by hand?