Microsoft Excel 2007 - Engineering Perspectives - Lecture Slides, Slides of Process Engineering

Download Microsoft Excel 2007 - Engineering Perspectives - Lecture Slides and more Slides Process Engineering in PDF only on Docsity!

Main Window

2

Office button

Quick access toolbar Tabs

Dialog box launcher

Ribbon (menu bars)

Formula

Status bar

Worksheet tabs

Worksheet

Ribbon

4

• Contains all the commands for working with spreadsheet content
• Commands related to a particular type of activity are grouped together
• Divided into 7 tabs, each focusing on a major activity area
• Ribbon is not customizable; you cannot change around the locations of the commands across the tabs or create new tabs
• You can hide the ribbon of a particular tab by double-clicking it. Double-clicking it again to bring the ribbon back

Groups and Dialog Box Launcher

5

Groups

Dialog box launcher

Quick Access Toolbar

7

• The only permanent toolbar and located next to the office button
• For holding the most frequently accessed commands
• Can be customized
  • Click one of the suggested commands from the drop down list
  • Click on the More Commands option and use the dialogue box which opens (shown opposite) to add more commands into the box on the right

Status Bar

8

• Page Layout
  • Work and type into a worksheet whilst the page margins, headers and footers are displayed
  • All the displayed elements can be directly edited
• Zooming Tools
  • Use the slider
  • Click the “+” or “-” button (increment/decrement of 10%)
  • Click on the Zoon Level box and select from the zoom dialog box

Views Zooms

Normal (^) Page Layout

Page break preview

Zoom dialog box

Formula

• 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

Fahrenheit Celsius

50 10 100 38 150 66 200 93 250 121 300 149 350 177 400 204 450 232 500 260

11

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).

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

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))

Statistical Analysis

• Statistical Functions

– Over 80 most commonly used statistical computations

• Data Analysis Tools

– If Analysis ToolPak is already installed, Data >> Data

Analysis

– Otherwise

• Office Button >> Excel Options >> Add-ins
• In the Manage box, select Excel Add-ins, click Go
• In the Add-ins available box, select Analysis ToolPak checkbox, then click OK

• Descriptive Statistics

– Data >> Data Analysis >> Descriptive Statistics

14

• Microsoft excel
• 4. Daily Rainfall
• Mean 4.
• Standard Error 0.
• Median
• Standard Deviation 1. Mode #N/A
• Sample Variance 2.
• Kurtosis 0.
• Skewness -0.
• Range 5.
• Minimum 1.
• Maximum 7.
• Sum 43.
• Count
• Confidence Level(95.0%) 1.

Excel Solver

• Load Solver

– If Solver is already installed, Data >> Solver

– Otherwise

• Office Button >> Excel Options >> Add-ins
• In the Manage box, select Excel Add-ins, click Go
• In the Add-ins available box, select Solver Add-in checkbox, then click OK

17