01:198:170 Lecture 19: Lecture #19

• School: Rutgers University
• Department: Computer Science
• Course: 01:198:170
• Professor: Stephen Stoll

Document Summary

Writing formula: highlight square & enter equal sign: all pound signs either indicates an error or that number is too large for the cell (adjust the cell size) Relative: if you copy & paste a formula into a different cell, the cell value will change based on difference in position (relative to cell) Absolute: always refer to a xed position use $ sign to lock in value (no matter where you paste a formula, that value will stay: left/up subtract; right/down add. Excel has built in formulas called functions: perform built in math operations (over 650 functions) 3 ways to get a formula: memorize, go to ribbon tab, or type in rst letter & it"ll show up: can also use show formula button to see formulas in the spreadsheet. Start with column where you want to look for data. Give range; range of data will not look left to your unique value.