week02 - WELCOME EF 105 Spring 2006 EF 105 Computer Methods...

Info iconThis preview shows pages 1–13. Sign up to view the full content.

View Full Document Right Arrow Icon
    WELCOME WELCOME EF 105                Spring 2006
Background image of page 1

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

View Full DocumentRight Arrow Icon
    EF 105 Computer Methods in Engineering  Problem Solving Lecture 2: Algebra and Trig Review Use of EXCEL Introduction Application
Background image of page 2
    Identify major components  of the Excel window Excel is a computerized spreadsheet, which is an  important business tool that helps you report and  analyze information.  Excel stores spreadsheets in documents called  workbooks.  Each workbook is made up of individual worksheets, or  sheets.  Because all sorts of calculations can be made in the  Excel spreadsheet, it is much more flexible than a paper  spreadsheet.  The Excel window has some basic components, such as  an Active cell, Column headings, a Formula bar, a Name  box, the mouse pointer, Row headings, Sheet tabs, a  Task Pane, Tab scrolling buttons and Toolbars. 
Background image of page 3

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

View Full DocumentRight Arrow Icon
    A sample Excel worksheet
Background image of page 4
    Excel worksheets and workbooks When you set up calculations in a worksheet, if an  entry is changed in a cell, the spreadsheet will  automatically update any calculated values that  were based on that entry. When you open Excel, by default it will open a  blank workbook with three blank worksheets.  When you save a workbook, you have a Save As  option that can save the spreadsheet to earlier  versions of Excel or to Quattro Pro, Lotus 123  formats, dBase formats, and even to a comma or  tab-delimited text file.
Background image of page 5

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

View Full DocumentRight Arrow Icon
    Identify Excel components
Background image of page 6
    Descriptions of Excel components
Background image of page 7

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

View Full DocumentRight Arrow Icon
    Navigate within worksheets To navigate within a workbook, you use the arrow  keys, PageUp, PageDown, or the Ctrl key in  combination with the arrow keys to make larger  movements.  The most direct means of navigation is with your  mouse.  Scroll bars are provided and work as they do in all  Windows applications.  To move to other Worksheets, you can:   Click their tab with the mouse Use the Ctrl key with the Page Up and Page Down keys  to move sequentially up or down through the  worksheets
Background image of page 8
    Navigation keystrokes
Background image of page 9

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

View Full DocumentRight Arrow Icon
    The Active Cell
Background image of page 10
    Developing a Worksheet Determine the worksheet’s purpose. Enter the data and formulas. Test the worksheet and make any  necessary edits / corrections. Document the worksheet and improve  appearance. Save and print the complete worksheet.
Background image of page 11

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

View Full DocumentRight Arrow Icon
    Entering Data into a Worksheet To enter data, first make the cell in which you  want to enter the data active by clicking it.
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 41

week02 - WELCOME EF 105 Spring 2006 EF 105 Computer Methods...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online