{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Computer Exercise #2 - Excel Introduction &amp; Compounding - 02-09-11

# Computer Exercise #2 - Excel Introduction & Compounding - 02-09-11

This preview shows pages 1–4. Sign up to view the full content.

EE 0822 INVE\$TING FOR THE FUTURE MR. LENGKEEK INVESTING TOOLS 2 EXCEL INTRODUCTION 1.1. BACKGROUND Excel is one of Microsoft’s utilities which allows you to do a number of very interesting and helpful things with numbers (data). We will be using Excel 2007, which is very similar to Excel 2003 in its ability to handle and manipulate data. However, there have been major changes in the user interface, and so although the various operations are the same, they have been moved from where they were in the 2003. So, if you are familiar with 2003, then all you need to do is to learn where those commands you were familiar with are now located in the 2007 version. 1.2. EXERCISES Directly below, is a screen shot of Excel 2007. Note that now there are three toolbars – the uppermost is where frequently accessed tools reside. The next toolbar down, the middle one, is similar to the one in Excel 2003. Finally, the lower toolbar contains the tools usually found in Excel 2003 when clicking on the middle toolbar. There are some tools in the middle toolbar which you will not find on your Excel 2007, e.g., Nuance PDF. Note each page of Excel is called sheet – short for spreadsheet. You can add another sheet or delete sheets from the file you are working with. For this course we will be dealing with only a very small set of tools that are available in Excel. Here are the operations we will learn. Generating a line plot and a scatter plot. Generating a bar chart. 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
EE 0822 INVE\$TING FOR THE FUTURE MR. LENGKEEK INVESTING TOOLS Generating equations. 1.2.1. STEPS NEEDED TO OBTAIN A LINE CHART. In a spreadsheet, each small rectangle is called a “cell”. You can enter numbers by placing the cursor in a cell, and then simply typing in the number. Hit the Enter tab and the number will be entered and the cursor will have moved down to the next adjacent cell. . Note - enter numbers 1 to 10 in order as shown on the right. For the example shown “1” is placed in cell B3 – where B is the column and 3 is the row Don’t worry about exactly where the numbers are placed, just that they are oriented similar to those shown on the right. Now to generate the line graph we must do the following. Click the Insert tab on the second toolbar – see chart below.. 2
EE 0822 INVE\$TING FOR THE FUTURE MR. LENGKEEK INVESTING TOOLS Outline the series of numbers we have, by placing the cursor over the first or last number and then holding down the left button and dragging the cursor to the end of the numbers. The numbers will be outlined with a black square. Now you can click on the Line chart tab and a drop down menu will appear as shown below. You then select the type of line plot you want. In this case we will select the first 2-D Line option. If you have followed the steps correctly you should have something which looks very similar to what is shown directly below.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 20

Computer Exercise #2 - Excel Introduction & Compounding - 02-09-11

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online