1 / 20

Microsoft excel 2003

Microsoft excel 2003. Dr. Yan Liu Department of Biomedical, Industrial and Human Factors Engineering Wright State University. Window. Default name. Title bar. Window. Menu bar provides the user one way to access Excel commands (i.e. actions performed on worksheet). Menu bar. Window.

clarke-wade
Télécharger la présentation

Microsoft excel 2003

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft excel 2003 Dr. Yan Liu Department of Biomedical, Industrial and Human Factors Engineering Wright State University

  2. Window Default name Title bar

  3. Window • Menu bar provides the user one way to access Excel commands (i.e. actions performed on worksheet) Menu bar

  4. Window Standard Toolbar • Toolbars provide quick and intuitive methods to access Excel commands without opening menus • Tools are depicted by icons Formatting Toolbar

  5. Window Formula bar Name box Formula box Active cell • Formula box displays contents typed in the active cell (cell with a heavy border) • Name box shows the cell reference of the active cell

  6. Window Question box • Question box is a handy way of starting Help Task pane • Task pane shows the tools that are likely to be used in the current task

  7. Window Columns Rows Cell A1 Workspace Worksheets

  8. Basic Operations • Concepts • Cell reference • Used to refer a specific cell • A combination of column name and row number • Range • A rectangular group of one or more cells • Denoted by the cell references of the top left cell and the bottom right cell separated by a colon • e.g. A1:B2 refers to the cells A1, A2, B1 and B2 • Selection • A cell is selected by clicking it • A range is selected by first clicking one of the four cells at its corner and then holding the mouse button and dragging the cursor over the range • Formatting • Change the manner in which a cell entry is displayed • Change the alignment, font, the number of decimals, show the value in number, percentage, fraction, currency, text, scientific notation, etc.

  9. Basic Operations • Entering Formulas • A formula is a mathematical expression that tells Excel to perform an operation • Begins with the equal symbol (=) • Arithmetic operators (in the order of precedence) • Negation (-) • Exponentiation (^) • Multiplication and division (*, /) • Addition and subtraction (+, -) • The precedence order may be overridden by using parentheses

  10. Suppose we have a laboratory heating apparatus with a thermometer calibrated in degrees of Fahrenheit. We need a table to give approximate Celsius values, shown as follows. It is known that Celsius = 5/9*(Fahrenheit – 32).

  11. Equal sign Arguments = ROUND (A10, 2) Function name Using Functions • Functions • Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure • Begins with an equal sign (=) • Followed by the function name • Finally arguments for the function separated by commas, enclosed in a pair of parentheses

  12. Zero argument: = PI () One argument: = SQRT (A2) Two arguments: = ROUND (A2,2) Variable arguments: = SUM (A1:A10) or = SUM(A1:A10,B3,B4) Nesting function: = SQRT(SUM (A1:A10)) Using Functions • Types of Functions • Ten categories • Mathematical & trigonometric, engineering, logical, statistical, date and time, database, financial, information, lookup and reference, and text • Arguments • The number of arguments in a function may be fixed, variable or even zero • The argument can also be a function itself (nesting function)

  13. Charts • Types of Charts • Twelve standard types • Column, bar, line, pie, XY scatterplot, area, doughnut, radar, surface, bubble, stock, cylinder, cone, and pyramid • Custom types • Twenty build-in types • User-defined • XY Scatterplot • Compares two variables at once (one on the horizontal X axis and the other on the vertical Y axis) • Useful in observing the relationship between two variables • Line Chart • Distributes the order of data evenly along the horizontal axis and numerical values of data evenly along the vertical axis  • Useful in displaying trends over time

  14. Chart title Y-axis Chart area Y-axis title Plot area Data series Marker Legend Gridline X-axis X-axis title Anatomy of Chart

  15. Statistical Analysis • Statistical Functions • Over 80 most commonly used statistical computations • Data Analysis Tools • Tools >> Data Analysis • Descriptive Statistics • A quick method: Tools >> Data Analysis >> Descriptive Statistics

  16. Statistical Analysis • Descriptive Statistics (Cont.) • Use statistical functions

  17. In-Class Exercise Go to course website http://www.engineering.wright.edu/~yan.liu/ISE210/ to download In-Class Exercise One. There are three problems in this exercise in three worksheets titled “Function”, “Chart” and “Descriptive Statistics”.

More Related