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

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

A spreadsheet is divided into ...Group of answer choiceslines and spaces.rows and columns.inputs and outputs.problems and solutions.