This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: Excel Primer To Start Excel : Double click on the Excel icon or select the program from the menu (often found under Recent Applications). A blank workbook page should appear containing a grid of cells with letters labeling columns and numbers labeling rows. If you dont have a blank Excel sheet you can obtain one by selecting File from the uppermost menu, and then New. On newer versions of Excel you will first open the Project Gallery and then open the Excel Workbook. To Enter Numbers and/or text: Click in the cell that you wish to type in. Enter numbers or text headings as desired. You can type in the formula bar: or you can type directly into the target cell. To enter your new information, click on the green or press the Enter key. If you change your mind and you want to leave the contents of the cell unchanged after you have started typing, just press the red X button. Your new text will be discarded. Formatting of cells can be accomplished by highlighting the cells you wish to have the formatting apply to and selecting the desired formatting option. This option can be selected on the toolbar (for example, B stands for bold, click on it to choose it) or by pulling down the Format menu and choosing Cells . In particular, you can change the number of significant figures displayed. For example, type "=PI()" into a cell just to get an example number. The result will be shown as 3.14159265 Now, highlight the cell, pull down the Format menu and choose Cells . Click on the Number tab and the "Number" category. Change the number of decimal points to the desired number: If you choose 3 decimal places the PI cell will now appear as: 3.142 You can also use the "Scientific" category to force the results to be listed in scientific notation. To Enter Formulas in Excel: To have Excel do a calculation for you, type the appropriate formula in the cell you wish the desired answer to appear, starting with an "=" sign. 2 Examples: a) to add the number in cell B1 to the value in cell E7 and have this sum appear in cell G22, type =B1+E7 in cell G22, then press the Enter key. b) to multiply the number in A5 by that in B5 and subtract 10,and have the value appear in C5, type = (( A5*B5) 10) in cell C5, and then press the Enter key {{ Note that division is denoted by a backslash / and multiplication is denoted by *}} c) to calculate the average, median, and standard deviation for the numbers in cells D3 to D22 type =AVERAGE(D3:D22), =MEDIAN(D3:D22), and =STDEV(D3:D22), respectively in the cells you wish these values to appear. Note that the colon specifies a range of cells....
View
Full
Document
This note was uploaded on 02/09/2010 for the course CH CH242 taught by Professor Katz during the Spring '10 term at Colby.
 Spring '10
 Katz

Click to edit the document details