SPREADSHEET MODELLING FINAL EXAM
LATEST 2026 ACTUAL EXAM QUESTIONS
AND CORRECT (VERIFIED ANSWERS) |
ALREADY GRADED A+
1. In a nonlinear optimization model, which of the following solvers is most
appropriate when the objective function and constraints are smooth but non-
convex?
a. Simplex LP
b. GRG Nonlinear
c. Evolutionary
d. Dual Simplex
answer:-b. GRG Nonlinear**
2. Which of the following is a key limitation of using the Scenario Manager in
Excel compared to a Data Table?
a. It cannot handle more than two input variables simultaneously
b. It requires VBA to function
c. It does not allow worksheet protection
d. It cannot produce summary reports
answer:-a. It cannot handle more than two input variables simultaneously**
3. When using Solver for a linear programming problem, the "Assume Linear
Model" option should be checked because it:
a. enables the use of integer constraints
b. uses the GRG method for faster convergence
,c. allows Solver to use the Simplex algorithm for greater efficiency and accuracy
d. automatically scales all variables to unit size
answer:-c. allows Solver to use the Simplex algorithm for greater efficiency and
accuracy**
4. What is the primary purpose of the "Set Objective" box in Solver?
a. To define the cell that contains the value of the objective function
b. To specify the constraints of the model
c. To select the solving method
d. To define variable cells
answer:-a. To define the cell that contains the value of the objective function**
5. In a Monte Carlo simulation using Excel, which function is most commonly
used to generate a random value from a normal distribution with a given mean and
standard deviation?
a. RAND()
b. RANDBETWEEN()
c. NORM.INV(RAND(), mean, stdev)
d. NORM.DIST()
answer:-c. NORM.INV(RAND(), mean, stdev)**
6. Which of the following statements about the "Evolutionary" solving method in
Solver is true?
a. It guarantees a globally optimal solution for convex problems
b. It is best suited for smooth, nonlinear problems
c. It uses genetic algorithms and is appropriate for non-smooth or discontinuous
problems
,d. It is the fastest method for linear programming
answer:-c. It uses genetic algorithms and is appropriate for non-smooth or
discontinuous problems**
7. A two-variable data table in Excel can vary:
a. one input value across multiple rows and columns
b. two input values, one across rows and one across columns, showing one output
c. two input values and show two outputs simultaneously
d. any number of inputs as long as outputs are in a single column
answer:-b. two input values, one across rows and one across columns, showing
one output**
8. What does the "Shadow Price" in Solver's sensitivity report indicate?
a. The amount the objective function would change if the right-hand side of a
constraint increased by one unit
b. The maximum possible improvement in the objective before the solution
changes
c. The reduced cost of a decision variable
d. The amount of slack in a constraint
answer:-a. The amount the objective function would change if the right-hand side
of a constraint increased by one unit**
9. Which Excel tool is most appropriate for finding the input value needed to
achieve a specific target result in a formula?
a. Goal Seek
b. Solver
c. Scenario Manager
, d. Data Table
answer:-a. Goal Seek**
10. In a linear programming sensitivity report, a "Reduced Cost" of zero for a
decision variable indicates:
a. the variable is not in the optimal solution
b. the objective coefficient can be increased without changing the solution
c. the variable is currently in the optimal solution at a positive level
d. the constraint associated with that variable is non-binding
answer:-c. the variable is currently in the optimal solution at a positive level**
11. Which of the following is an example of a "binary constraint" in Solver?
a. A constraint that requires a cell to be either 0 or 1
b. A constraint that forces a cell to be an integer
c. A constraint that sets a cell equal to another cell
d. A constraint that limits a cell to be non-negative
answer:-a. A constraint that requires a cell to be either 0 or 1**
12. The "Analysis ToolPak" add-in in Excel provides which of the following
capabilities?
a. Advanced statistical analysis including regression, ANOVA, and t-tests
b. Monte Carlo simulation with built-in distributions
c. Optimization with genetic algorithms
d. Automated pivot table creation
answer:-a. Advanced statistical analysis including regression, ANOVA, and t-
tests**
LATEST 2026 ACTUAL EXAM QUESTIONS
AND CORRECT (VERIFIED ANSWERS) |
ALREADY GRADED A+
1. In a nonlinear optimization model, which of the following solvers is most
appropriate when the objective function and constraints are smooth but non-
convex?
a. Simplex LP
b. GRG Nonlinear
c. Evolutionary
d. Dual Simplex
answer:-b. GRG Nonlinear**
2. Which of the following is a key limitation of using the Scenario Manager in
Excel compared to a Data Table?
a. It cannot handle more than two input variables simultaneously
b. It requires VBA to function
c. It does not allow worksheet protection
d. It cannot produce summary reports
answer:-a. It cannot handle more than two input variables simultaneously**
3. When using Solver for a linear programming problem, the "Assume Linear
Model" option should be checked because it:
a. enables the use of integer constraints
b. uses the GRG method for faster convergence
,c. allows Solver to use the Simplex algorithm for greater efficiency and accuracy
d. automatically scales all variables to unit size
answer:-c. allows Solver to use the Simplex algorithm for greater efficiency and
accuracy**
4. What is the primary purpose of the "Set Objective" box in Solver?
a. To define the cell that contains the value of the objective function
b. To specify the constraints of the model
c. To select the solving method
d. To define variable cells
answer:-a. To define the cell that contains the value of the objective function**
5. In a Monte Carlo simulation using Excel, which function is most commonly
used to generate a random value from a normal distribution with a given mean and
standard deviation?
a. RAND()
b. RANDBETWEEN()
c. NORM.INV(RAND(), mean, stdev)
d. NORM.DIST()
answer:-c. NORM.INV(RAND(), mean, stdev)**
6. Which of the following statements about the "Evolutionary" solving method in
Solver is true?
a. It guarantees a globally optimal solution for convex problems
b. It is best suited for smooth, nonlinear problems
c. It uses genetic algorithms and is appropriate for non-smooth or discontinuous
problems
,d. It is the fastest method for linear programming
answer:-c. It uses genetic algorithms and is appropriate for non-smooth or
discontinuous problems**
7. A two-variable data table in Excel can vary:
a. one input value across multiple rows and columns
b. two input values, one across rows and one across columns, showing one output
c. two input values and show two outputs simultaneously
d. any number of inputs as long as outputs are in a single column
answer:-b. two input values, one across rows and one across columns, showing
one output**
8. What does the "Shadow Price" in Solver's sensitivity report indicate?
a. The amount the objective function would change if the right-hand side of a
constraint increased by one unit
b. The maximum possible improvement in the objective before the solution
changes
c. The reduced cost of a decision variable
d. The amount of slack in a constraint
answer:-a. The amount the objective function would change if the right-hand side
of a constraint increased by one unit**
9. Which Excel tool is most appropriate for finding the input value needed to
achieve a specific target result in a formula?
a. Goal Seek
b. Solver
c. Scenario Manager
, d. Data Table
answer:-a. Goal Seek**
10. In a linear programming sensitivity report, a "Reduced Cost" of zero for a
decision variable indicates:
a. the variable is not in the optimal solution
b. the objective coefficient can be increased without changing the solution
c. the variable is currently in the optimal solution at a positive level
d. the constraint associated with that variable is non-binding
answer:-c. the variable is currently in the optimal solution at a positive level**
11. Which of the following is an example of a "binary constraint" in Solver?
a. A constraint that requires a cell to be either 0 or 1
b. A constraint that forces a cell to be an integer
c. A constraint that sets a cell equal to another cell
d. A constraint that limits a cell to be non-negative
answer:-a. A constraint that requires a cell to be either 0 or 1**
12. The "Analysis ToolPak" add-in in Excel provides which of the following
capabilities?
a. Advanced statistical analysis including regression, ANOVA, and t-tests
b. Monte Carlo simulation with built-in distributions
c. Optimization with genetic algorithms
d. Automated pivot table creation
answer:-a. Advanced statistical analysis including regression, ANOVA, and t-
tests**
