Question 1

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.

Accepted Answer

This is the correct series of steps to create a scenario in Excel.

Question 2

While merging scenarios,one should keep both workbooks from which one wants to merge scenarios open,and work from the workbook to which one will add the scenarios.

Accepted Answer

This is because one needs to have access to both workbooks in order to merge the scenarios.

Question 3

In which of the following dialog boxes will you click Load/Save to save a problem model?
A) Options
B) Solver Results
C) Solver Parameters
D) Show Trial Solution

Accepted Answer

The Load/Save button to save a problem model is located in the Solver Parameters dialog box in Excel.

Question 4

To create a forecast sheet,enter two data series corresponding to each other in a worksheet,select both the data series,then click on the following: Data tab > Forecast group > Forecast Sheet > Create Forecast Worksheet box > Select Line Chart or Column Chart > Pick an end date in Forecast End box > Create.

Accepted Answer

This is the correct procedure to create a forecast sheet in Excel.

Question 5

To edit a scenario,click on the series: Tools menu > Scenarios > Scenario Manager > Highlight the name of the scenario whose values you want to change > Edit button > Edit Scenario dialog box > Edit as desired > OK button > Scenario Values dialog box > Change values stored in the scenario as desired > OK.

Accepted Answer

This is the correct sequence of steps to edit a scenario in Microsoft Excel.

Question 6

In which of the following dialog boxes,under Subject to the Constraints,will you click the constraint that you want to change and then click Change?
A) Options
B) Solver Results
C) Solver Parameters
D) Show Trial Solution

Accepted Answer

To change a constraint, you need to go to the Solver Parameters dialog box, where you can select the constraint you want to modify under the Subject to the Constraints section and then click on the Change button. The Options dialog box allows you to specify various solver settings, Show Trial Solution displays the values of the decision variables for the trial solution, and Solver Results provides information about the optimization process and the final solution.

Question 7

In which of the following dialog boxes will you click "Add" under "Subject to the Constraints" to add constraints to a model?
A) Options
B) Solver Results
C) Solver Parameters
D) Show Trial Solution

Accepted Answer

In the Solver Parameters dialog box, there is a section labeled "Subject to the Constraints" where you can add constraints to your model. Clicking "Add" will allow you to specify the constraints you want to add.

Question 8

Johnson wants to load Solver in Microsoft Excel.For this,he clicks the series: File > Options > Add-Ins > Manage Box > X > Go > Add-ins available box > Solver Add-in check box > OK.What can X be in the procedure?
A) COM Add-ins
B) Excel Add-ins
C) Disabled Items
D) XML Expansion Packs

Accepted Answer

The option "Excel Add-ins" allows the user to access additional features and functions that are not included in the standard installation of Microsoft Excel. The Solver Add-in is one of these additional features that is used for optimization and solving linear equations.

Question 9

To delete a scenario,first close the Document Inspector,then click on the following series: Data > What-If Analysis > Scenario Manager > Select the scenario you want to remove in Scenarios box > Delete.

Accepted Answer

This is the correct process to delete a scenario in Excel.

Question 10

To create a scenario summary report,click on the series: Data tab > Data tools > What-If Analysis > Scenario Manager > Summary button > Scenario Summary dialog box > Select Scenario PivotTable report for Report type > OK.

Accepted Answer

The answer of To create a scenario summary report,click on...

Quiz 9: Formula Auditing, data Validation, and Complex Problem Solving

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.

While merging scenarios,one should keep both workbooks from which one wants to merge scenarios open,and work from the workbook to which one will add the scenarios.

In which of the following dialog boxes will you click Load/Save to save a problem model?

In which of the following dialog boxes,under Subject to the Constraints,will you click the constraint that you want to change and then click Change?

In which of the following dialog boxes will you click "Add" under "Subject to the Constraints" to add constraints to a model?

Johnson wants to load Solver in Microsoft Excel.For this,he clicks the series: File > Options > Add-Ins > Manage Box > X > Go > Add-ins available box > Solver Add-in check box > OK.What can X be in the procedure?

To delete a scenario,first close the Document Inspector,then click on the following series: Data > What-If Analysis > Scenario Manager > Select the scenario you want to remove in Scenarios box > Delete.

To create a scenario summary report,click on the series: Data tab > Data tools > What-If Analysis > Scenario Manager > Summary button > Scenario Summary dialog box > Select Scenario PivotTable report for Report type > OK.