Question 1

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.
A) Limits
B) Answer
C) Sensitivity
D) Scenario

Accepted Answer

After Solver finds a solution, you can generate an Answer report, which summarizes the target cells, adjustable cells, and constraints.

Question 2

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.
A) changing cell
B) constraint
C) objective cell
D) solving method

Accepted Answer

Constraints in Solver are conditions that limit the solution to a set of possible values. Changing cells are the cells that can be changed to find a solution, objective cell is the cell that needs to be optimized and solving method is the technique used to find a solution.

Question 3

Arlo wants to use Goal Seek to answer a what-if question in a worksheet.Which button should he click on the Data tab to access the Goal Seek command?
A) What-if Analysis
B) Data Validation
C) Consolidate
D) Relationships

Accepted Answer

The Goal Seek command is found under the What-if Analysis button on the Data tab in Excel.

Question 4

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.
A) Analysis ToolPak
B) Solver PivotTable
C) Answer Report
D) Scenario Summary report

Accepted Answer

The Answer Report summarizes the target cells, adjustable cells, and constraints of the Solver solution. It also includes information on the Solver parameters, such as the solution time and number of iterations. The Analysis ToolPak is a separate Excel add-in that allows for statistical analysis, but does not pertain to Solver solutions. The Solver PivotTable and Scenario Summary report are not relevant to generating summaries of Solver solutions.

Question 5

Which of the following Excel features finds a numeric solution to a problem involving several input values?
A) Solver
B) PivotTable
C) one-variable data table
D) Goal Seek

Accepted Answer

Solver is an Excel feature that finds a numeric solution to a problem involving several input values by adjusting multiple variables to achieve a desired outcome.

Question 6

How can you tell if Solver is activated in your version of Excel?
A) The Solver button appears in the Analyze group on the Data tab.
B) A Solver tab appears on the ribbon.
C) The Solver dialog box opens when you click the Data tab.
D) Solver appears as the Add-in document property in Backstage view.

Accepted Answer

The Solver button appears in the Analyze group on the Data tab when Solver is activated in Excel.

Question 7

Which type of constraint should you use to limit the answer to whole numbers, such as for employees needed?
A) bin
B) < (less than)
C) integer
D) = (equals)

Accepted Answer

The integer constraint should be used to limit the answer to whole numbers.

Question 8

To combine the results of four separate scenarios, you create an Answer report.

Accepted Answer

To combine the results of four separate scenarios, you would use a Scenario Summary report, not an Answer report. Scenario Summary reports in Excel, for example, allow you to compare and summarize the outcomes of different scenarios created within a spreadsheet.

Question 9

In a two-input data table, you can vary the results in two cells and see the recalculated results.

Accepted Answer

In a two-input data table, you can vary the results in two cells and see the recalculated results.

Question 10

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

Accepted Answer

In the Scenario Manager dialog box, the changing values are the cells that will be changed to reflect the effect of the scenario.

Question 11

You can create a query to by adding what type of data to the data model?
A) Current worksheet data
B) Outlook address book
C) Word document
D) Word mail merge

Accepted Answer

A query in Excel is created by adding current worksheet data to the data model. The other options (Outlook address book, Word document, Word mail merge) are not relevant for creating a query in Excel.

Question 12

Which of the following Solver constraints should you delete if the range A5:F5 must contain exact dollar amounts such as $500.25?
A) A5:F5 = 500.25
B) iA5:F5 = int
C) A5:F5 = bin
D) A5:F5 >= 0

Accepted Answer

iA5:F5 = int is a constraint that forces the values in the range A5:F5 to be integers. This constraint should be deleted if the range must contain exact dollar amounts such as $500.25.

Question 13

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

Accepted Answer

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

Question 14

You can use Forecast Sheet to project future data based on past trends.

Accepted Answer

Forecast Sheet in Excel can analyze and project future trends based on past data.

Question 15

A one-input data table shows the result of varying one input value.

Accepted Answer

A one-input data table allows for the input value to be varied while keeping all other variables constant, resulting in a table that shows the corresponding output values.

Question 16

To analyze the results of scenarios, you can create a(n) _____.
A) Scenario Management chart
B) Scenario Overview
C) Scenario PivotTable
D) Answer report

Accepted Answer

A Scenario PivotTable allows for easy analysis of data from multiple scenarios using a variety of data aggregation and visualization tools. The other options are either not specific to scenario analysis or do not provide as comprehensive analysis capabilities.

Question 17

Excel Solver is a(n) _____, which means it must be installed before you can use it for the first time.
A) constraint
B) hidden feature
C) macro
D) add-in

Accepted Answer

Excel Solver is an add-in, which means it is not a built-in feature of Excel and must be installed separately before it can be used.

Question 18

You can merge scenarios to apply scenarios from another worksheet into the current one.

Accepted Answer

This is a true statement. In Excel, it is possible to merge scenarios from another worksheet into the current worksheet to combine and analyze various scenarios. This feature can be accessed under the "Scenario Manager" option in the "Data" tab.

Question 19

A scenario is a named set of values you use in a what-if analysis to store and observe different worksheet
results.

Accepted Answer

This statement is true. A scenario is a way to store different sets of input values for a what-if analysis, allowing you to easily switch between and compare different results.

Question 20

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

Accepted Answer

To edit the changing values for a scenario, you should use the Scenario Manager in Excel, not edit the data directly on the worksheet after applying the scenario.

Quiz 7: Excel

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

Arlo wants to use Goal Seek to answer a what-if question in a worksheet.Which button should he click on the Data tab to access the Goal Seek command?

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.

Which of the following Excel features finds a numeric solution to a problem involving several input values?

How can you tell if Solver is activated in your version of Excel?

Which type of constraint should you use to limit the answer to whole numbers, such as for employees needed?

To combine the results of four separate scenarios, you create an Answer report.

In a two-input data table, you can vary the results in two cells and see the recalculated results.

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

You can create a query to by adding what type of data to the data model?

Which of the following Solver constraints should you delete if the range A5:F5 must contain exact dollar amounts such as $500.25?

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

You can use Forecast Sheet to project future data based on past trends.

A one-input data table shows the result of varying one input value.

To analyze the results of scenarios, you can create a(n) _____.

Excel Solver is a(n) _____, which means it must be installed before you can use it for the first time.

You can merge scenarios to apply scenarios from another worksheet into the current one.

A scenario is a named set of values you use in a what-if analysis to store and observe different worksheet results.

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.