Deck 8: Performing What-If Analyses

Question 1

A student enters the names of months in cells A2 to A5 with the heading "Month" in cell A1.Then he enters the number of days in each moth in cells B2 to B5 with the heading "Days" in cell B2.In order to arrange the names of the months in cells A6 to E6 with heading "Month" in cell A6 and the number of days each month in cells A7 to E7 with heading "Days" in cell A7,he can use the formula =TRANSPOSE(A1:B5).

Answer 1

True

Question 2

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

Answer 2

C

Question 3

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.

Answer 3

True

Question 4

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

Question 5

One can manage available Office add-ins by clicking Gear icon > Settings > Mail > Options pane > General > Manage add-ins > Add/ Uninstall/ find more add-ins.

Question 6

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) Outline
B) Analyze
C) Forecast
D) Connections

Question 7

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

Question 8

To open the add-ins dialog box while activating an Excel add-in,we need to click on the Manage box > Excel Add-ins > Go.

Question 9

Which of the following will you click on the Reports list box in Solver Results dialog box to produce an Answer Report?

A) Limits
B) Answer
C) Sensitivity
D) Outline Reports

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.

Question 11

While deleting a constraint,which of the following relationships will you click for integer to appear in the Constraint box?

A) bin
B) int
C) >=
D) <=

Question 12

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.

Question 13

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

Question 14

If you remove an add-in,the changes are not saved until you exit MS Excel.

Question 15

Lola wants to install an add-in in Excel.She has to unblock the add-in to allow Excel to open the add-in file automatically.To do this,she right clicks on the add-in file and selects an option from the menu.What could the option be?

A) Copy
B) Delete
C) Rename
D) Properties

Question 16

Which of the following will you select as X in the following series of clicks to create a number format code in a chart: Home tab > Number Format > More Number Formats > Format Cells Dialog Box > Category Box > X > Type list > Type Box > Number format you want to customize > Make changes in it?

A) Special
B) Custom
C) Fraction
D) Percentage

Question 17

There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.

Question 18

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.

Question 19

George wants to apply the time number format to time entered in a cell as '11:30'.Which of the following options,when chosen as X,will help him to do? Ctrl+1 < Category < X < Type < 13:30?

A) Date
B) Time
C) Number
D) Currency

Question 20

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.

Question 21

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.

Question 22

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.