When you have completed all of the required items listed below, please save the spreadsheet file as initiallastnamequiz3.xls (my file would be called emeyertholenquiz3.xls) and email it to me before the due date.
Please do not wait until the last minute to do this assignment.
1. Download the file quiz3template.xls from here. Once you have saved the file, open it using Excel. Rename the file initiallastnamequiz3.xls.
2. Open the file using Excel (of course). You will find that there are two worksheets in this file, one is name ‘values’ and the other is ‘Quiz Sheet". The ‘values’ sheet contains three columns of data under the label Time and Distance. This data represents my times when I ran the New York Marathon last year. (If you were to examine one of the cells in any of the columns, you would find that these values are generated using a formula. Occasionally, you may find that the values in the columns may change for no apparent reason - this is normal and will not affect your ability to complete the exercises.)
3. Your first job is to copy data on the ‘values’ sheet and paste the values (NOT the formulas!!) to the ‘Quiz Sheet’. This requires the use of the Paste Special menu item in the edit menu. Format the values so that they contain only 2 places to the right of the decimal point. In some manner, please make sure that it is clear to the reader (me) what the values are. It is best if you were to add labels to your sheet to identify what your calculated numbers represent. Your sheet should look like the one below although you actual numbers will be different.
4. Prepare a chart (an XY also known as a scatter chart) of the data (DO NOT CONNECT THE DOTS). The data will (almost) fit on a straight line (which means that I ran at a consistent rate throughout the race). The graph will have a gray background and gridlines, please make the background white and remove gridlines. Be sure that there is a title and that there are labels on each axis. The following figures will help you do this.
A. Select data to graph: Highlight the data you wish to graph, with the x axis values should be the first column (which they are). Note that the titles are highlighted as well.
B. Use the Menu item INSERT and choose CHART
C. You will now go through a series of dialog boxes. the first one selects Chart Type: we always choose Scatter and for this one, choose the picture that has data points with no lines, as shown below.
D. Press the Next button to get the next box. This just shows the Source Data - since you highlighted the data to graph initially, you do not need to do anything on this box. Press next.
E. The third box allows you to add labels and format the graph (a bit). Put in labels for the Title of the graph (whatever you feel is appropriate), and labels for each of the axes. This is shown below.
F. Most scientific graphs usually do not have gridlines, so lets remove them. Press the Gridlines tab at the top of this dialog box. Uncheck the MAJOR GRIDLINES box - this will remove them. We will not make any other changes at this time, but you may wish to browse through the different tabs and note what you can do with them. Press the Next button.
G. I always like to have the chart on a new sheet, so in the last box, choose that option and press Finish. Your graph will now appear on a new sheet.
