Question 1

Which type of spreadsheet cell represents the left hand sides LHS)formulas in an LP model?

Accepted Answer

Constraint cells represent the LHS of the constraints in an LP model. These are the cells that define the limitations or requirements on the decision variables in the model.

Question 2

In the Analytic Solver Platform dialog box simple upper and lower bounds for decision variables are specified by

Accepted Answer

Simple upper and lower bounds for decision variables are specified by referring directly to the decision variable cells in the Constraints-Bound area. This is typically done by adding constraints such as "Variable X >= 0" or "Variable Y <= 10" directly in the spreadsheet.

Question 3

An LP problem with a feasible region will have

Accepted Answer

In LP, the optimal solution is always at one of the extreme points (also known as vertices) of the feasible region. Therefore, option B is correct as the LP problem will have an optimal solution at some extreme point. Option A and D are incorrect as they mention optimal solutions at interior points, which is not always true. Option C is incorrect as the optimal solution may or may not be at the origin, depending on the problem's constraints and objective function.

Question 4

What does the Excel "=SUMPRODUCTA1:A5,C6;C10)" function do?

Accepted Answer

The =SUMPRODUCT function multiplies each pair of cells in two arrays matched by position and sums the products. In this case, the arrays are A1:A5 and C6:C10.

Question 5

Models which are setup in an intuitively appealing,logical layout tend to be the most

Accepted Answer

Models that are set up in an intuitively appealing, logical layout facilitate easier auditing because their structure and logic can be more readily understood and reviewed by others.

Question 6

The "Analyze Without Solving" tool in Analytic Solver Platform is useful for

Accepted Answer

The "Analyze Without Solving" tool in Analytic Solver Platform allows users to check the equations in a spreadsheet model for consistency and errors without actually solving the optimization problem. It is a useful tool for verifying the assumptions and constraints in a model.

Question 7

The "Objective Value of" option in the Analytic Solver Platform task pane may be used to

Accepted Answer

The "Objective Value of" option allows the user to find a solution for a specific objective function value. This option is particularly useful when trying to achieve a specific goal or target, and the user knows the objective function value they need to achieve. The other options (A, B, and D) are more generic and do not allow the user to specify a particular objective function value.

Question 8

What action is required to make Analytic Solver Platform ASP)solve a specified problem?

Accepted Answer

Clicking the "Optimize" button on the ASP Ribbon, or the green arrow "Solve" in the task pane will initiate the solving process for the specified problem. Typing go in cell A1, clicking the Close button, or clicking the Guess button are not valid actions to initiate problem-solving in Analytic Solver Platform.

Question 9

Numeric constants should be

Accepted Answer

Numeric constants should be placed in individual cells so that they can be easily changed if necessary without having to manually update the formula in multiple places. This also makes the model more organized and easier to read.

Question 10

The constraints X₁≥ 0 and X₂≥ 0 are referred to as

Accepted Answer

These constraints ensure that the variables XS1U1B11 and XS1U1B12, when multiplied by S1U1B0, are nonnegative. This is known as nonnegativity or positivity constraint.

Question 11

Which tab in the Analytic Solver Platform task pane is used to define an optimization problem?

Accepted Answer

The "Model" tab is used to define an optimization problem in the Analytic Solver Platform task pane.

Question 12

Which type of spreadsheet cell represents the decision variables in an LP model?

Accepted Answer

The variable cells in a spreadsheet represent the decision variables in an LP model. These cells contain the values of the variables that need to be determined in order to optimize the objective function while meeting the constraints.

Question 13

Problems which have only integer solutions are called

Accepted Answer

Problems which have only integer solutions are called integer programming problems. Discrete programming problems may or may not be restricted to integer solutions, while infeasible programming problems have no feasible solutions.

Question 14

Microsoft Excel contains a built-in optimizer called

Accepted Answer

Microsoft Excel contains a built-in optimizer called "Solver" which is a tool for optimizing mathematical models. It is used to find the optimal solution for a problem by changing multiple inputs that affect a single output (known as the objective function). Solver is particularly useful in decision-making processes where there are multiple constraints that need to be taken into account.

Question 15

What function is used to add the contents of cells A1,A2 and A3?

Accepted Answer

The addition function in Excel is represented by the plus sign (+). Therefore, the correct formula to add the contents of cells A1, A2 and A3 would be =A1+A2+A3.

Question 16

Which type of spreadsheet cell represents the objective function in an LP model?

Accepted Answer

The objective function is represented by the objective cell in an LP model.

Question 17

The built-in Solver in Excel is found under which tab on the ribbon?

Accepted Answer

The Solver function in Excel is related to data analysis and therefore can be found under the Data tab on the ribbon.

Question 18

Spreadsheet modeling is an acquired skill because

Accepted Answer

The spreadsheet is free-form, providing many modeling options, which means there is not just one correct solution or method for building a model, and acquiring the skill requires practice and experience. The other options are incorrect as there are often multiple correct ways to build a model, using Analytic Solver Platform is not necessarily required for spreadsheet modeling, and spreadsheets are generally considered to be easy to use.

Question 19

The "Objective Sense" option in the Analytic Solver Platform task pane may be used to

Accepted Answer

The "Objective Sense" option in the Analytic Solver Platform task pane is used to tell the Solver what value it should seek for your optimization objective. It allows you to specify whether you want to maximize or minimize the objective function.

Question 20

Which function is equivalent to =SUMPRODUCTA1:A3,B1:B3)?

Accepted Answer

The function =A1*B1+A2*B2+A3*B3 is equivalent to =SUMPRODUCTA1:A3,B1:B3. Both functions calculate the sum of the products of corresponding values in the specified ranges.

Quiz 3: Modeling and Solving Lp Problems in a Spreadsheet

Which type of spreadsheet cell represents the left hand sides LHS) formulas in an LP model?

In the Analytic Solver Platform dialog box simple upper and lower bounds for decision variables are specified by

An LP problem with a feasible region will have

What does the Excel "=SUMPRODUCTA1:A5,C6;C10) " function do?

Models which are setup in an intuitively appealing,logical layout tend to be the most

The "Analyze Without Solving" tool in Analytic Solver Platform is useful for

The "Objective Value of" option in the Analytic Solver Platform task pane may be used to

What action is required to make Analytic Solver Platform ASP) solve a specified problem?

Numeric constants should be

The constraints X₁≥ 0 and X₂≥ 0 are referred to as

Which tab in the Analytic Solver Platform task pane is used to define an optimization problem?

Which type of spreadsheet cell represents the decision variables in an LP model?

Problems which have only integer solutions are called

Microsoft Excel contains a built-in optimizer called

What function is used to add the contents of cells A1,A2 and A3?

Which type of spreadsheet cell represents the objective function in an LP model?

The built-in Solver in Excel is found under which tab on the ribbon?

Spreadsheet modeling is an acquired skill because

The "Objective Sense" option in the Analytic Solver Platform task pane may be used to

Which function is equivalent to =SUMPRODUCTA1:A3,B1:B3) ?

Quiz 3: Modeling and Solving Lp Problems in a Spreadsheet

Which type of spreadsheet cell represents the left hand sides LHS) formulas in an LP model?

In the Analytic Solver Platform dialog box simple upper and lower bounds for decision variables are specified by

An LP problem with a feasible region will have

What does the Excel "=SUMPRODUCTA1:A5,C6;C10) " function do?

Models which are setup in an intuitively appealing,logical layout tend to be the most

The "Analyze Without Solving" tool in Analytic Solver Platform is useful for

The "Objective Value of" option in the Analytic Solver Platform task pane may be used to

What action is required to make Analytic Solver Platform ASP) solve a specified problem?

Numeric constants should be

The constraints X1 ≥ 0 and X2 ≥ 0 are referred to as

Which tab in the Analytic Solver Platform task pane is used to define an optimization problem?

Which type of spreadsheet cell represents the decision variables in an LP model?

Problems which have only integer solutions are called

Microsoft Excel contains a built-in optimizer called

What function is used to add the contents of cells A1,A2 and A3?

Which type of spreadsheet cell represents the objective function in an LP model?

The built-in Solver in Excel is found under which tab on the ribbon?

Spreadsheet modeling is an acquired skill because

The "Objective Sense" option in the Analytic Solver Platform task pane may be used to

Which function is equivalent to =SUMPRODUCTA1:A3,B1:B3) ?

The constraints X₁≥ 0 and X₂≥ 0 are referred to as