KEY CONCEPTS IN SPREADSHEET
MODELING AND DECISION ANALYSIS
EXAM QUESTIONS AND CORRECT
ANSWERS. VERIFIED 2025/2026.
Which of the following skills are important to be an effective spreadsheet modeler? -
ANS Basic Algebra, Basic Probability, Simple Logic (if, Max, Min, etc.)
Which type of thinking is directed toward achieving a goal, a single solution, answer, or result? -
ANS Convergent
Which of the following are reasons for studying modeling? - ANS Generate insight, Improve
thinking skills, Improve quantitative reasoning skills, Experiment and learn
What is the term for a process of creating a simplified representation of reality and working
with this represention to understand or control some aspect of the world? - ANS Modeling
Problems with clear objectives, obvious assumptions, readily available data, and well
understood logical structure are which type of problems? - ANS Well-structured
What shape on an influence chart indicates a Decision? - ANS Square
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, The problem-solving process uses which of the following types of thinking at each stage? -
ANS Both divergent and convergent
Which type of thinking stressed generating ideas over evaluating ideas? - ANS Divergent
One guideline to consider when designing a spreadsheet suggests that the designer should:
1. anticipate who will use the spreadsheet
2. consider what kinds of questions the user will want to address
3. make it easy to dchange parameters that can bve expected to change often
4. make it easy to find key outputs by collecting them in one place
5. include graphs of the outputs to make it easier to learn from the spreadsheet
This list describes which of the guidelines the spreadsheet designer should keep in mind? -
ANS Design for use
Which of the following is a set of parameters that describes an internally consistent view of the
future? - ANS Scenarios
Which of the following testing activities should the spreadsheet developer do to ensure the
plausibility/reasonableness of the results of a spreadsheet? - ANS Test extreme cases, Check
with a calculator, Make rough estimates
The diagram below is what type of diagram? - ANS Influence chart
Which of the following is a term used to indicate an early working version of a model? -
ANS Prototype
What technique of designing a spreadsheet can be used to place similar necessary information
in logical locations in a spreadsheet? - ANS Organize into modules
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
MODELING AND DECISION ANALYSIS
EXAM QUESTIONS AND CORRECT
ANSWERS. VERIFIED 2025/2026.
Which of the following skills are important to be an effective spreadsheet modeler? -
ANS Basic Algebra, Basic Probability, Simple Logic (if, Max, Min, etc.)
Which type of thinking is directed toward achieving a goal, a single solution, answer, or result? -
ANS Convergent
Which of the following are reasons for studying modeling? - ANS Generate insight, Improve
thinking skills, Improve quantitative reasoning skills, Experiment and learn
What is the term for a process of creating a simplified representation of reality and working
with this represention to understand or control some aspect of the world? - ANS Modeling
Problems with clear objectives, obvious assumptions, readily available data, and well
understood logical structure are which type of problems? - ANS Well-structured
What shape on an influence chart indicates a Decision? - ANS Square
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, The problem-solving process uses which of the following types of thinking at each stage? -
ANS Both divergent and convergent
Which type of thinking stressed generating ideas over evaluating ideas? - ANS Divergent
One guideline to consider when designing a spreadsheet suggests that the designer should:
1. anticipate who will use the spreadsheet
2. consider what kinds of questions the user will want to address
3. make it easy to dchange parameters that can bve expected to change often
4. make it easy to find key outputs by collecting them in one place
5. include graphs of the outputs to make it easier to learn from the spreadsheet
This list describes which of the guidelines the spreadsheet designer should keep in mind? -
ANS Design for use
Which of the following is a set of parameters that describes an internally consistent view of the
future? - ANS Scenarios
Which of the following testing activities should the spreadsheet developer do to ensure the
plausibility/reasonableness of the results of a spreadsheet? - ANS Test extreme cases, Check
with a calculator, Make rough estimates
The diagram below is what type of diagram? - ANS Influence chart
Which of the following is a term used to indicate an early working version of a model? -
ANS Prototype
What technique of designing a spreadsheet can be used to place similar necessary information
in logical locations in a spreadsheet? - ANS Organize into modules
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
