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

Accepted Answer

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

Accepted Answer

The Load/Save option is available in the Solver Parameters dialog box, allowing users to save the problem model for future use or reference. The Options dialog box provides settings for the Solver, while the Solver Results dialog box displays the results of the Solver's calculations. The Show Trial Solution dialog box allows users to view the Solver's trial solution for a given model.

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.

Accepted Answer

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

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

Accepted Answer

X can be Excel Add-ins, as we are trying to add an add-in to Microsoft Excel. COM Add-ins, Disabled Items, and XML Expansion Packs are not relevant to this procedure.

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.

Accepted Answer

The steps mentioned are correct for managing Office 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

Accepted Answer

Xavier should select "Analyzing" as X in order to use Solver to find optimal solutions for his decision problem. The Solver tool is used for optimization and analysis, and selecting "Analyzing" in this step will allow Xavier to input his decision variables and constraints and find the optimal solution using the Simplex LP method.

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

Accepted Answer

In Solver Parameters dialog box, under the Subject to the Constraints section, you can click on the constraint that you want to change and then click on the Change button to make modifications. This option allows you to modify the constraints that you have previously defined. The Options dialog box allows you to specify various settings for Solver, The Solver Results dialog box displays the results of the solved problem, and the Show Trial Solution dialog box allows you to examine the trial solutions generated by Solver.

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.

Accepted Answer

When we click on the Manage box in Excel, then select "Excel Add-ins" and click on "Go", it opens the "Add-Ins" dialog box where we can manage, activate, or deactivate the Excel add-ins.

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

Accepted Answer

Clicking on "Answer" in the Reports list box will produce an Answer Report, which shows the final values of the decision variables, the objective function value, and any constraints that were binding. The other options listed in the question (Limits, Sensitivity, Outline Reports) produce different types of 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.

Accepted Answer

The correct steps to create a scenario summary report involve selecting "Scenario Summary" for the Report type, not "Scenario PivotTable report."

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

Accepted Answer

The 'int' relationship is used to indicate that the variable is an integer in the constraint. 'bin' is used for binary variables only. '>=' and '<=' are used for inequality constraints.

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.

Accepted Answer

This statement is true. A one-variable data table allows you to vary a single input cell and see how different values affect the result of a 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

Accepted Answer

The "Add" button under "Subject to the Constraints" is present in the Solver Parameters dialog box, which is where constraints can be added to a model in Excel Solver. The other options listed do not have a feature for adding constraints.

Question 14

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

Accepted Answer

The answer of If you remove an add-in,the changes are...

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

Accepted Answer

The option that Lola would select from the menu would be "Properties". This is because unblocking an add-in in Excel requires adjusting the file's properties, specifically the security properties. By selecting "Properties", Lola can access the security properties and unblock the add-in so that Excel can open it automatically. Options like Copy, Delete, and Rename would not be related to unblocking the add-in.

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

Accepted Answer

In order to create a custom number format code, we need to select "Custom" in the Category Box. The other options (Special, Fraction, and Percentage) already have predefined number formats and do not allow us to make changes to create a custom format.

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.

Accepted Answer

The limit of changing cells in the Edit Scenario dialog box is 35, meaning that only 35 cells 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.

Accepted Answer

This statement is true. To create 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. The row values represent one variable, and the column values represent the other variable, and the data table calculates the result of a formula using all possible combinations of the input values.

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

Accepted Answer

The best choice is Time as George wants to format the time entered in a cell. The other options such as Date, Number, and Currency have different formats and are not relevant to the given requirement.

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.

Accepted Answer

This is the correct procedure to delete a scenario in Microsoft Excel.

Quiz 8: Performing What-If Analyses

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

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.

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?

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.

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?

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

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.

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

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.

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

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

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?

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?

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.

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.

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?

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.