Using Excel Spreadsheet
Essay Preview: Using Excel Spreadsheet
Report this essay
User Guide for Excel Modification
In this guide we are going to show you how to retrieve your e-mail in Web version of Outlook and change an excel spreadsheet. With your computer turn on, click on your web browser and type
Next we need to do is update your excel spreadsheet. So click on start find the icon that says My Computer click on it once. Then click twice on your screen name on starlinghome there you should find your document label Homework 1 Spreadsheet. If you dont see it scrolls down with your mouse or the scroll bar on your right side of the browser. When you find your attachment point at it and click on your left mouse button two times. Then wait for it to open.
Now we need to make some changes to this document. First we need is to delete column C move your pointer to the letter C and click on it with your right button. The column should be outlined and a box will open, scroll down until you get to delete then click on it. Next we need to add another column in. Right click on the letter C again scroll down the box until you find insert click on it. Now you will have a new column this time you will see a painter brush on the top right hand side click on it, make sure you have check mark on Format Same as Right. This will copy the formatting and the statistical formulas to the new column in your spreadsheet.
Now we need to enter some new data in are fields. Take a look on your left hand side you will see a bunch of numbers. Now take a look at the top again you have a row of alphabets. We need to go to cell C6 starting from the top I want you to go down the C row until it corresponds to row 6 from their you will enter your new year. Click cell C6 an enter 2002. Go to the next cell C7 an enter Q2. Now we need to cell C9 to start entering are new numbers. In cell C9 enter 12.50 in C10 enter 14.30 in cell C11 enter 21.5 and finally in C12 enter 8.8. Now we are going to need to add a sum formula in cell C14. Click on cell C14 an enter =SUM(C9:C12). You should see $57.1. Next we need to have an Average so click on cell C15 an enter =Average(C9:C12). Your Average should come out to $14.3; if your number is not coming out correctly check your number from