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
 Fall '08
 Staff
 the00, cell00, a00

Click to edit the document details