excel functions v8

excel functions v8 - Spreadsheet Functions CEE3804:...

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

View Full Document Right Arrow Icon
Spreadsheet Functions CEE3804: Computer Applications for Civil and Environmental Engineers
Background image of page 1

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

View Full DocumentRight Arrow Icon
Spring 2007 CEE 3804 2 1. Topics to be Covered Understanding Excel’s Error Codes Auditing Worksheet Formulas Using Excel’s Built-in Functions Lookup Functions Financial Functions Date/Time Functions Financial Functions
Background image of page 2
Spring 2007 CEE 3804 3 1. Function Basics Formula results depend on the operator sequencing and precedence: (2+6)/2 = 4 2+6/2 = 5 Excel sequence in operations: left to right: parentheses exponential calculations multiplication and division addition and subtraction
Background image of page 3

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

View Full DocumentRight Arrow Icon
Spring 2007 CEE 3804 4 1. Function Basics b. Reference Operators Excel uses three reference operators: the colon: cells between and including two cell references e.g. A1:A5 refers to A1, A2, A3, A4, and A5 the comma: indicates the union of two ranges e.g. A1:A3,B4,B6:B7 refers to A1, A2, A3, B4, B6, and B7 the space: indicates the intersection of two ranges C1:C5 B3:G3 refers to cell C3
Background image of page 4
Spring 2007 CEE 3804 5 1. Function Basics c. Creating Names and Using Text Define range including row and column names: Insert/Name/Create Creates names for rows and columns A3: Nice B3: Person C3: A3&” “&B3 gives Nice Person
Background image of page 5

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

View Full DocumentRight Arrow Icon
Spring 2007 CEE 3804 6 1. Editing Formulas a. Overview To edit a formula: press F2 or double-click on the cell dependent cell references are color coded to simplify editing can dependent cell references with the mouse Can edit formula in the formula palette result will be updated as the formula is edited
Background image of page 6
Spring 2007 CEE 3804 7 2. Editing Formulas b. Decoding Error Values - Overview Excel errors begin with a “#” sign: #DIV/0 #N/A #NAME? #NUM! #REF! #VALUE! #NULL!
Background image of page 7

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

View Full DocumentRight Arrow Icon
Spring 2007 CEE 3804 8 2. Editing Formulas c. Decoding Error Values - #DIV/0 and #N/A #DIV/0: divide-by-zero error indicates that the denominator evaluates to zero Note: empty cells evaluate to zero #N/A: Not available error varies depending on formula: lookup function: no value available data: data not yet available charting features ignore #N/A can include in a formula - NA(): Example: if(B7=0, NA() ,B7)
Background image of page 8
Spring 2007 CEE 3804 9 2. Editing Formulas d. Decoding Error Values - #NAME? and #NUM! #NAME?: Name Error Excel cannot evaluate a defined name used in formula #NUM!: Number Error Number cannot be interpreted: too small or too big does not exist
Background image of page 9

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

View Full DocumentRight Arrow Icon
Spring 2007 CEE 3804 10 2. Editing Formulas e. Decoding Error Values - #REF!, #VALUE! and #NULL! #REF!: Reference Error
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 60

excel functions v8 - Spreadsheet Functions CEE3804:...

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

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