Quiz 9: Chapter 8

One can create a one-variable data table in Excel to test a series of values for a single input cell and see the influence of these values on the result of a related formula. TRUE OR FALSE

TRUE

To create a scenario, one should click on the series: Data tab > Data tools > What-If Analysis > Scenario Manager > Add button > Enter details in the boxes in Edit Scenario dialog box> OK > Close button. TRUE OR FALSE

TRUE

While creating a two-variable data table in Excel, you need to enter two ranges of possible input values, one in a row and another in a column. True or False

Truee

While deleting a constraint, which of the following relationships will you click for integer to appear in the Constraint box? a. int b. bin c. <= d. >=

a. int

Xavier wants to use a solver to find optimal solutions for a decision problem. What should he select as X in the series of clicks for this purpose: Data tab > X > Solver > Enter Solver parameters (read on) > Check "Make Unconstrained Variables Non-Negative" > Select "Simplex LP" > Solve? a. Forecast b. Connections c. Outline d. Analyze

d. Analyze

Which of the following will you click on the Reports list box in Solver Results dialog box to produce an Answer Report? a. Sensitivity b. Outline Reports c. Limits d. Answer

d. Answer