Microsoft+Excel+9

=**FAST CARS**=

[|Reference Material]
 * This assignment is to see if you can create formulas using the formula button and making a chart with chart wizard.**
 * The Fast Car Club is testing different sports cars and storing the results in the spreadsheet.**
 * **You are to create a spreadsheet just like the one below.**
 * Speed Test** ||  ||
 * Car** ||
 * Distance (feet)** ||
 * Time (Seconds)** ||
 * Paul’s Porsche** ||
 * 123.5** ||
 * 7.68** ||
 * Frank’s Ferrari** ||
 * 145.7** ||
 * 7.77** ||
 * Amy’s Aston-Martin** ||
 * 150** ||
 * 7.90** ||
 * Carla’s Corvette** ||
 * 156.3** ||
 * 6.50** ||
 * Jason’s Jaguar** ||
 * 124** ||
 * 5.34** ||
 * Sarah’s Supra** ||
 * 137** ||
 * 7.09** ||
 * 6.50** ||
 * Jason’s Jaguar** ||
 * 124** ||
 * 5.34** ||
 * Sarah’s Supra** ||
 * 137** ||
 * 7.09** ||
 * 137** ||
 * 7.09** ||
 * **In cell right of the one with //Time (seconds)// type “//Speed (feet/sec.)//” Speed is calculated by dividing distance traveled by time.**
 * **Write a formula in the cell below the one you just created to calculate the speed. Don’t forget to start the formula with an =.**
 * **Use the Fill Down command to fill in the rest of the column.**
 * **In the cell that is two below that of the last //Time// type the words //Average Speed//.**
 * **You want to find the average speed. Click in the cell to the right of the cell that you were and under //Speed (feet/sec)//.**
 * **Click on the //fx// button at the top next to the text box.**
 * **You should get a formula box.**
 * **Find the word Average. Highlight it and click OK**
 * You should get this box:**
 * **Click Ok. //You should get your calculation//.**
 * Now we need to edit the cells so they round off to two decimal places.**
 * **Highlight the cells in the column with Speed that has the numbers.**
 * **Format the cells to two decimal places.**
 * **Add a chart to compare speeds by following the next step.**
 * **Select cells from //Cars// to //Speed// and down to the row with //Sarah’s Supra//.**
 * **Click on Chart wizard icon. [[image:file:///C:%5cDOCUME%7e1%5csbuster%5cLOCALS%7e1%5cTemp%5cmsohtml1%5c01%5cclip_image018.gif width="24" height="19"]]**
 * **Select the column graph. Hit next**
 * **In the next screen. Click on the Tab that says //Series//.**
 * **Click on the Distance and click on Remove button.**
 * **Do the same for Time. Then click next.**
 * **Click Finish.**
 * This sets up a chart with the car names and just comparing their speed.**
 * **Place the chart below the information. Click on Print under the //File menu// and go to Page Setup. Click on the button that says Landscape. This will print the spreadsheet along the length of the page.**
 * **Go to //Tools// and click on //Spelling.// Check your spreadsheet.**
 * **Save it as //Speed//.**