Spreadsheets_28Aug11

Absolute addressing the addressed cell is with respect

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ABS, SQRT   COS, SIN, LN, EXP   IF, ISBLANK, ISTEXT   Refer to Excel Func?ons file 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.

Ask a homework question - tutors are online