FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Performing What-If Analyses

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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?

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

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

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?

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.

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?

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.

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

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.

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.

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.

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

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?

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.

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?

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