Excelprimer - Excel Primer To Start Excel Double click on...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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 don’t 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.
Image of page 1

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

View Full Document Right Arrow Icon
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.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern