Excel+Exercise


 * 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? Annie's Excel Exercise
 * 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? Read it like a chart
 * 5) Here is the problem you will enter data for and chart:

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
 * 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 gets hidden so you have to enlarge the cell size
 * 4) Make an adjustment to the columns to make the text fit. How did you do it? Drag the cell out until it fits all of the words
 * 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? It moves to the left size
 * 2) Center the data in both columns.
 * 3) <span class="Normal�120�Char" style="text-decoration: none;">Highlight all the data and the titles you have entered. How can you tell it’s highlighted? It is in a blue box Where is the beginning of the highligh t? C9 How do you know?it starts with the white box
 * 4) <span class="Normal�121�Char" style="text-decoration: none;">Create a Chart using the Chart Wizard:
 * 5) <span class="Normal�122�Char" style="text-decoration: none;">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) <span class="Normal�123�Char" style="text-decoration: none;">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?
 * 8) <span class="Normal�124�Char" style="text-decoration: none;">Choose XY (Scatter) and choose one to the sub-types with lines. Note the XY. What shou ld that remind you of? the XY axis in a graph chart
 * 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) <span class="Normal�125�Char" style="text-decoration: none;">Click Next

<span class="Normal�126�Char" style="text-decoration: none;">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. <span class="Header�128�Char" style="text-decoration: none;">From looking at the chart:
 * 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.
 * 1) <span class="Normal�127�Char" style="text-decoration: none;">Click on the Finish bu tton to create the chart
 * 1) <span class="Header�129�Char" style="text-decoration: none;">What is the dependent variable? How do you know? The dependent variable is the number of developing clams because is depends on the water temperature.
 * 2) <span class="Header�130�Char" style="text-decoration: none;">What is the independent variable? How do you know? The water temperature because that is what we can change to affect the results of the number of clams
 * 3) <span class="Header�131�Char" style="text-decoration: none;">What is the optimum temperature for clam development? Why? 40 degrees because it
 * 4) <span class="Header�132�Char" style="text-decoration: none;">How does this chart compare with the one y ou drew by hand? this chart is digital and easier to make