The DSS task with the spreadsheet was done by the majority of the students properly, using the correct formulas connecting one parametric cell (Inflation Rate) to all cells in the Future Cost column and eventually changing Future Profit cells too by changing ONLY ONE Inflation Rate cell.
Do the required reading of Excel tutorial on absolute reference or google any other tutorial on absolute and relative references. Notice that if the formula is done with the use of absolute reference than it can be copied to ALL other cells of the column and the result will still be correct although it refers to same one Inflation Rate cell. If yo do not use absolute reference that you will have either insert 1.04 manually in all cells or the copying from one cell of the same column to other column cells will not work!
No comments:
Post a Comment