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

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 one of the following models is not suitable for accommodating any change?

Question 2Which spreadsheet feature uses a set of instructions to perform calculations, such as addition or subtraction?1 pointFormatFilterFunctionFormula