SPREADSHEET MODELING FOR
DECISION MAKING AND ANALYSIS.
EXAM QUESTIONS AND CORRECT
ANSWERS. VERIFIED 2025/2026.
Spreadsheet Modeling - ANS Creating abstract representations for decision-making scenarios.
Decision Model - ANS Generalization of relationships between inputs and outputs.
Deterministic Model - ANS Model with known parameters; outputs fully determined.
Stochastic Model - ANS Model incorporating randomness; outputs vary with inputs.
Inputs - ANS Variables manipulated to affect target outputs.
Outputs - ANS Outcome values of a decision we wish to know.
Processes - ANS Calculations linking inputs with outputs in models.
What-if Analysis - ANS Evaluating outcomes by changing input variables.
Spreadsheet Engineering - ANS Designing, constructing, and testing spreadsheet models.
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
DECISION MAKING AND ANALYSIS.
EXAM QUESTIONS AND CORRECT
ANSWERS. VERIFIED 2025/2026.
Spreadsheet Modeling - ANS Creating abstract representations for decision-making scenarios.
Decision Model - ANS Generalization of relationships between inputs and outputs.
Deterministic Model - ANS Model with known parameters; outputs fully determined.
Stochastic Model - ANS Model incorporating randomness; outputs vary with inputs.
Inputs - ANS Variables manipulated to affect target outputs.
Outputs - ANS Outcome values of a decision we wish to know.
Processes - ANS Calculations linking inputs with outputs in models.
What-if Analysis - ANS Evaluating outcomes by changing input variables.
Spreadsheet Engineering - ANS Designing, constructing, and testing spreadsheet models.
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.