ADM 1370 Lecture Notes - Lecture 2: Lookup Table, Emv, Pearson Product-Moment Correlation Coefficient

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Umar Ruhi

Document Summary

Relative cell references: cell addresses that are adjusted as a formula containing these addresses is copied within spreadsheet. Used by default in most spreadsheet calculations. B6 copied over two columns to the right will become d6. K12 copied over one column to the left and one row above will become j11. Absolute cell references: cell addresses that stay fixed & are not adjusted as a formula is copied. Used when the formulas should always use the value in a particular cell. Used for constant values (e. g. sales tax rate etc. ) Mixed cell references: cell addresses where either row or column is fixed. refers to a cell address where the column is fixed to b but the row can increase or decrease as the formula is copied vertically. J refers to a cell address where the column can vary as the formula is copied horizontally but the row is fixed to 11.