16 Review Later Identify which of the following is not a goal of the variance dashboard. Conveying a lot of information as quickly as possible Presenting several different types of information all on one screen Using graphs in place of tables where appropriate A detailed written report 17 Review Later To find out the value of the assumptions that are needed to hit a certain budget target, you would use to optimize output, you would an use Solver, goal seek Pivot table, consolidate Consolidate, pivot table Goal seek, solver 18 Review Later Which of the following is not an advantage to link workbooks? Provides flexible reporting system Small management budget templates can be sent to budget holders Different spreadsheets can be worked on simultaneously by different people The links will update themselves when the file name changes Review Later Use the same Excel data in the previous question and run a multiple regression to estimate the relationship between promotion, advertising (independent variables) and revenue (dependent variable). Calculate the revenue if the promotion cost is $150 and the advertising COst is $250. 1624,33 1060.83 1358.71 1743.04 20