Question 1

Solver is an add-in,a program that adds customized commands and features to Microsoft Office programs such as Excel.

Accepted Answer

Solver is a commonly used add-in in Microsoft Excel that provides optimization and simulation functionality.

Question 2

Two-variable data tables are often used to explore the impact of changing two values on a single result.

Accepted Answer

Two-variable data tables allow for the simultaneous manipulation of two variables and observe their effect on a single result, so the statement is true.

Question 3

A limits report is best utilized when your problem contains integer constraints.

Accepted Answer

A limits report is typically used in linear programming to understand the sensitivity of the optimal solution to changes in the coefficients of the objective function, not specifically for integer constraints.

Question 4

In a two-variable data table,the values of two result cells are displayed.

Accepted Answer

A two-variable data table in Excel displays the results of one formula cell, not two.

Question 5

When you create a one-variable data table,you select the range that contains the data table,making sure to include the column headings.

Accepted Answer

A one-variable data table in Excel requires selecting the range that includes the formula and the input values, but it does not necessarily require column headings.

Question 6

If your input values are in a column,you will use the Row input cell option when you use the Data Table command.

Accepted Answer

If input values are in a column, you will use the Column input cell option when you use the Data Table command. If input values are in a row, then you would use the Row input cell option.

Question 7

-You cannot merge scenarios in situations involving multiple workbooks.

Accepted Answer

The answer of 
-You cannot merge scenarios in situations involving...

Question 8

The sensitivity report is most often used in science and engineering environments.

Accepted Answer

The sensitivity report is a tool used in optimization modeling, which is commonly used in science and engineering environments.

Question 9

-If the dialog box in the accompanying figure is used to unlock the changing cells in the scenario,and the worksheet is protected,users can show the scenario but not edit it.

Accepted Answer

If a worksheet is protected, users can view scenarios but cannot edit them unless they have the password to unprotect the sheet.

Question 10

-The item marked 1 in the accompanying figure indicates the profit.

Accepted Answer

The answer of 
-The item marked 1 in the accompanying...

Question 11

With what-if analysis,you specify the result values you want,and Excel changes the input values to produce them.

Accepted Answer

What-if analysis in Excel involves changing input values to see how they affect the outcome, not specifying the result values to change inputs.

Question 12

You should always clearly label the row or column containing the input and result values.

Accepted Answer

It is important to clearly label input and result values in order to avoid confusion and ensure accurate analysis.

Question 13

That an order must meet store demand,or that it cannot exceed the available parts,are examples of constraints.

Accepted Answer

Constraints are limitations or restrictions on what can be done, and these examples show how certain factors limit the options for fulfilling an order.

Question 14

Using Solver,you specify the target cell,variable cells,and constraints on a problem.

Accepted Answer

This statement is true. Solver is a tool in Microsoft Excel that allows users to optimize a problem by specifying a target cell (the cell that contains the formula that you want to optimize), variable cells (cells that can change to meet the constraints), and constraints (limitations or restrictions that must be met). Solver then calculates the optimal values for the variable cells to achieve the desired result.

Question 15

At the break-even point,revenue equals expenses.

Accepted Answer

At the break-even point, a company earns enough revenue to cover all expenses and does not make a profit or loss. Therefore, revenue equals expenses.

Question 16

Changing cells can be located anywhere in the worksheet.

Accepted Answer

Changing cells can be located anywhere in the worksheet as long as they are within the range of the formulas or functions that reference them.

Question 17

References,or limits,in Solver are important because they ensure a realistic solution to your problem.

Accepted Answer

The answer of References,or limits,in Solver are important because they...

Question 18

To open the Goal Seek dialog box,first click the What-If Analysis button in the Data Tools group.

Accepted Answer

This is correct. To open the Goal Seek dialog box, first click the What-If Analysis button in the Data Tools group.

Question 19

It is possible for Solver to be installed but not activated on your computer.

Accepted Answer

It is possible to install Microsoft Excel's Solver add-in without activating it. Activation requires purchasing a license or using a trial version.

Question 20

As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

Accepted Answer

The answer of As in traditional what-if analysis,Goal Seek starts...

Quiz 10: Performing What-If Analyses