Question 1

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

Accepted Answer

Choosing "Time" format under "Type" will allow George to apply the time number format to the time entered in the cell as "11:30".

Question 2

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

Accepted Answer

In this series of clicks, Xavier would need to select "Add-Ins" as X in order to access the Solver tool. Since he is looking to find optimal solutions for a decision problem, he would want to choose "Analyzing" as his tool, as this involves analyzing an optimization problem to find the best solution. The other options (Outline, Forecast, and Connections) do not relate to solving optimization problems.

Question 3

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

False

Question 4

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

Accepted Answer

The option she would select is "Properties" which will open a window where she can check the box to unblock the add-in and allow it to open automatically in Excel.

Question 5

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.

Accepted Answer

This is correct. In a two-variable data table, one range of input values should be entered in a row and another range of input values should be entered in a column. The intersection of these ranges will create the table.

Question 6

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 Microsoft Excel.

Question 7

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.

Accepted Answer

This is true. One can use a one-variable data table in Excel to easily test a series of values for a single input cell and see the impact of these values on the result of a related formula.

Question 8

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

Accepted Answer

The "int" relationship is used to indicate that a variable should take on an integer value. This is the closest relationship to the term "integer" and would be the appropriate choice for deleting a constraint involving an integer variable.

Question 9

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

Accepted Answer

To create a custom number format in a chart, you need to select "Custom" in the Category Box of the Format Cells Dialog Box. This will bring up the Type list, where you can select the type of number format you want to customize (e.g. currency, date, time). Once you've selected the type of format, you can make changes to it in the Type Box, such as adjusting the number of decimal places or changing the currency symbol.

Question 10

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

The steps mentioned are correct to delete a scenario in Excel.

Question 11

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.

Accepted Answer

The statement is true. The Edit Scenario dialog box allows you to modify up to 35 changing cells in the Scenario Values dialog box.

Question 12

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.

Accepted Answer

This is the correct sequence of steps to open the add-ins dialog box and activate an Excel add-in.

Question 13

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

Accepted Answer

When you remove an add-in in MS Excel, any changes made to the workbook using that add-in will not be saved until you exit Excel. This is because Excel needs to reload the add-in and update the workbook before it can save any changes made using the add-in.

Question 14

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, under the "Subject to the Constraints" section, there is an "Add" button available to add constraints to the model. The Options dialog box is used to change the default settings for Solver, the Solver Results dialog box displays the solution after running Solver, and the Show Trial Solution dialog box displays possible solutions for a Solver problem without actually solving it.

Question 15

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

In the Solver Parameters dialog box, under the Subject to the Constraints section, you can select the constraint that you want to change and then click the Change button to adjust its parameters. The other options listed do not include a Subject to the Constraints section or a Change button in the relevant dialog box.

Question 16

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 option to save a problem model is found in the Solver Parameters dialog box. This allows you to save the current model settings and parameters as a file which can be loaded at a later time, avoiding the need to recreate the same settings from scratch. The other options listed do not have a Load/Save function.

Question 17

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

Accepted Answer

The answer of A student enters the names of months...

Question 18

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.

Accepted Answer

This is the correct sequence to manage available Office add-ins.

Question 19

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

X refers to Excel Add-ins, as Solver is an add-in for Microsoft Excel. COM Add-ins and XML Expansion Packs are other types of add-ins, but they are not relevant for loading Solver. Disabled Items are items that have been manually disabled and will not be helpful in this situation.

Question 20

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

Accepted Answer

Clicking on "Answer" in the Reports list box will produce an Answer report, which shows the optimal solution, the variable values, and the objective function value.

Quiz 8: Performing What-If Analyses

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?

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?

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.

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?

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

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.

While deleting a constraint, which of the following relationships will you click for integer to appear in the Constraint 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.

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 open the add-ins dialog box while activating an Excel add-in, we need to click on the Manage box > Excel Add-ins > Go.

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

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, 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 Load/Save to save a problem model?

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.

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?

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