Questions 100% Solved!!
Building spreadsheet models, often called _____________, is part art and part science -
ANSWERspreadsheet engineering
The Process of developing good, useful, and correct spreadsheet models is known as spreadsheet
engineering
A. True
B. False - ANSWERTrue
The Process of developing good, useful, and correct spreadsheet models is known as spreadsheet
_________ - ANSWERengineering
In predictive modeling, validity refers to how well a model represents reality.
A. True
B. False - ANSWERA.
In predictive modeling, ______ refers to how well a model represents reality.
A. True
B. False - ANSWERvalidity
Two-way data tables can evaluate only one output variable
A. True
B. False - ANSWERA.
Two-way data tables can __________only one output variable - ANSWERevaluate
Models can capture every detail of a real problem
A. True
B. False - ANSWERFalse
, Verification is the process of ensuring that a model is accurate and free from logical errors
A. True
B. False - ANSWERTrue
___________ is the process of ensuring that a model is accurate and free from logical errors -
ANSWERVerification
Excel Formula Auditing tools (in the Formulas tab) help you validate the formulas and check for
errors
A. True
B. False - ANSWERA.
One useful Excel tool is the data error feature, which allows you to define acceptable input values in
a spreadsheet and provides an error alert if an invalid entry is made.
A. True
B. False - ANSWERB.
A wide variety of practical problems in business analytics can be modeled using spreadsheets.
A. True
B. False - ANSWERA.
A wide variety of practical problems in business analytics can be modeled using _____________ -
ANSWERspreadsheets
__________________ is a visual representation of a descriptive model that shows how the elements
of the model influence or relate to others. - ANSWERInfluence diagram
Adding more realism to a model reduces its complexity.
A. True
B. False - ANSWERF.