Exam 8: Performing What-If Analyses

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.

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?

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

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.

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 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).

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?

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.

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.

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

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.

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.

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

In which of the following dialog boxes will you click Load/Save to save a problem 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?

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,under Subject to the Constraints,will you click the constraint that you want to change and then click Change?

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.

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

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.