When setting up the spreadsheet for using Scenario Manager, all calculations must be made by using cell references if possible. This is because ________?
1) values in the spreadsheet will be updated automatically
2) cell references are easier to understand
3) cell references allow for easier editing and updating
4) values in the spreadsheet will not be updated when changes are made in the data