ACIS 1504 Lecture Notes - Lecture 8: Dollar Sign, Decision Points, Lookup Table
26 Aug 2016
School
Department
Course
Professor
Document Summary
Order of operations- parentheses, multiplication and division, addition and subtraction. Usually if function exists, you should use it & take advantage. Redundancy is bad, duplicating data is bad. instead of copy and paste do. =cell reference. b/c anything changed in that cell referenced changes for all those cells who uses it. Not going to burry in a formula or a function. (do not put into an equation) create assumption worksheet. When creating equation don"t go back to original worksheet once selected assumption just hit enter. Assumption should be isolated, aka not shown in calculation. Only numbers allowed to put into equation that 100% sure like 24 hours in a day, 7 days a week. Can refere to cell by : relative, absolute, mixed. Absolute (hardly ever use) has two dollar signs dollar sign in front of row and column. Mixed has one dollar sign, either in front of row or column.
