This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ABS, SQRT COS, SIN, LN, EXP IF, ISBLANK, ISTEXT Refer to Excel Func?ons ﬁle in the Course Materials/Support Files area on Blackboard — Provided to you in exams. Cell Addressing in Formulas Rela?ve Addressing
the addressed cell is with respect to where the cell containing the formula is. =A3+B4 entered in cell A4 means add value in cell above current cell to value to the right of current cell so when copied to cell C5 becomes = C4+D5 Cell Addressing in Formulas . Absolute addressing
the addressed cell is with respect to the spreadsheet In Excel, precede column and/or row with $ sign: $B2 means col B is absolute but row 2 is rela?ve C$3 means col C is rela?ve but row 3 is absolute $A$1 means both col A & row 1 are absolute Example A1
A2
A3 B1
B2
B3 C1
C2
C3 =A1+A2+A3 Copy to C4 =C1+C2+C3 Example A1
A2
A3 B1
B2
B3 C1
C2
C3 =$A1+$A2+A3 Copy to...
View
Full
Document
This note was uploaded on 12/01/2012 for the course ECE 1331 taught by Professor Staff during the Fall '08 term at University of Houston.
 Fall '08
 Staff

Click to edit the document details