ADM 1370 Lecture 13: Future Value Function
Document Summary
Transpose turning rows into columns and vice versa. Values (pastes the results of formulas) this pastes the values calculated, and not the actual formulas. When referring to the same cell range over and over, you can give it a name. Every single time you use a customized name, you are giving an absolute reference to the cell. Excel can support approximately one million rows, and sixteen thousand columns. It"s easier to scroll up and down, than to scroll left and right. Problem-solving and modeling process: identify problem and acquire data, develop model, analyze model, test results, perform sensitivity analysis how sensitive is your model to small input values. How sensitive is the model to these changes: present results and implement solution. Attempt to recreate real life situations in a simpler way. Usually simplified versions of the things they represent. Physical/scale models (aerodynamics, buildings small scare constructions of the models. ) Mathematical models / data models (financial analysis)