User Guide for Excel Modification

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 https://mail.lhup.edu/. You should have a dialog box pop up you need to click yes. A screen will open for you to enter your screen id and password. When Outlook opens on your right hand side should be a list of items you want to make sure that inbox is in a blue box, in the middle is a list of all the mail you have received. Look for a message that titled Homework 1 Spreadsheet. Click twice to open the message. You should have a dialog box opening. Look at your message; you should see in the middle a link to download an attachment. Place your pointer over the link and right click on it. Scroll down the list until it says Save Target as… click on it another box should appear. We will save this to your local hard drive so while the box is open click on the My Computer icon. Then click twice on your screen name on ‘starlinghome’ and hit save. When you have downloaded your attachment hit the close button. Close out any other browser or dialog box on your screen. You have just completed the first phase of your assignment.

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 don’t 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 C9