Spreadsheet models are referred to as what-if models because they _____.Group of answer choicesallow easy instantaneous recalculation for a change in model inputshave specialized functions to perform detailed analysiscome preloaded on computersare mathematical and logic-based models

Spreadsheets/Excel: With reference to a spreadsheet model, an uncontrollable model input is known as a(n)Group of answer choices

Steps in Developing a Spreadsheet Model:Group of answer choicesConstraints, Data cells, Changing cells, Objective cellChanging cells, Constraints, Data cells, Objective cellObjective cell, Constraints, Changing cells, Data cellsChanging cells, Data cells, Objective cell, ConstraintsData cells, Changing cells, Objective cell, Constraints

Which of the following design guidelines, if followed, enables the user to update the model parameters without the risk of mistakenly creating an error in a formula?Group of answer choicesUsing simple formulasUsing numbers in the spreadsheet formulaDocumenting the spreadsheet modelSeparating the parameters from the spreadsheet model

Which of the following Microsoft Excel tool lets you Test out scenarios and determine the range of outcomes without changing the actual data?SolverWhat-If-AnalysisMacros

he major purpose of Scenario Analysis in Excel is A. To evaluate different sets of assumptionsB.  To run simulations to predict future outcomes