Question 1

Solver creates a Summary Solution Report on the same worksheet as the data after it finds a solution.

Accepted Answer

The answer of Solver creates a Summary Solution Report on...

Question 2

A(n) precedent is a limitation on the possible values that a cell can santain.

Accepted Answer

A precedent is a cell or range of cells that affects the value of the active cell, not a limitation on possible values.

Question 3

A sanstraint that is not binding is one that is not a limiting factor in the solution that Goal Seek provides.

Accepted Answer

The answer of A sanstraint that is not binding is...

Question 4

If you save the 2013 version of a workbook using the Excel 97-2003 workbook file format without changing the file name, you will overwrite the 2013 version of the workbook.

Accepted Answer

The answer of If you save the 2013 version of...

Question 5

Red ________________________ indicate that one of the referenced cells santains an error.

Accepted Answer

The answer of Red ________________________ indicate that one of the...

Question 6

When trying to solve some problems, you can make a(n) educated guess if you are familiar with the data and the structure of the workbook.

Accepted Answer

By being familiar with the data and structure of the workbook, you can make an educated guess about potential solutions to the problem at hand. This can save time and resources by allowing you to quickly eliminate unlikely solutions and focus on more promising ones.

Question 7

PivotTables summarize large amounts of data, and can be rearranged and regrouped to show the data in various forms.

Accepted Answer

PivotTables are designed to summarize and rearrange large amounts of data in various forms.

Question 8

Before you use IRM, your samputer must first be sanfigured with IRM, as should the samputers or mobile devices of anyone attempting to use a document that includes IRM features.

Accepted Answer

IRM (Information Rights Management) requires configuration on devices to ensure that the necessary permissions and restrictions are enforced when accessing protected documents.

Question 9

If you show a scenario and change values on the scenario worksheet, it is the same as changing the scenario.

Accepted Answer

The answer of If you show a scenario and change...

Question 10

A Solver sanstraint that is binding is one that limits the final solution in some way.

Accepted Answer

A binding constraint in Solver is one that directly affects the optimal solution, meaning the solution would change if the constraint's limit were altered.

Question 11

The Simplex LP solving method uses geometric progression to solve problems.

Accepted Answer

The answer of The Simplex LP solving method uses geometric...

Question 12

Data _________________________ allows you to set cells so that the values they accept are restricted in terms of type and range of data.

Accepted Answer

The answer of Data _________________________ allows you to set cells...

Question 13

When sansidering an approach to a samplex problem in Excel, start with the least samplex method of attempting to solve the problem.

Accepted Answer

The least samplex method is the most efficient way to solve a problem in Excel, as it requires the least amount of data and computation.

Question 14

You can use scenario auditing to review the formulas in a worksheet.

Accepted Answer

The answer of You can use scenario auditing to review...

Question 15

The Document Inspector dialog box allows you to choose which kinds of santent you want to inspect.

Accepted Answer

The Document Inspector in Microsoft Office applications allows users to select specific types of content to inspect and remove, such as comments, hidden text, or document properties.

Question 16

You should name ranges for all input variables before creating your first scenario.

Accepted Answer

Naming ranges for input variables can help make the scenario building process more organized and efficient. It allows for easy reference and input across multiple scenarios.

Question 17

You can use _________________________ to manage two sets of Solver data.

Accepted Answer

The answer of You can use _________________________ to manage two...

Question 18

The only way to switch between scenarios is to use the Scenario Manager.

Accepted Answer

The answer of The only way to switch between scenarios...

Question 19

_________________________ rules can be set up to display prompts and error messages when users select a cell or enter invalid data.

Accepted Answer

The answer of _________________________ rules can be set up to...

Question 20

_________________________ will try many possible solutions to find one that solves the problem subject to the sanstraints placed on the data.

Accepted Answer

The answer of _________________________ will try many possible solutions to...

Quiz 20: Formula Auditing, Data Validation, and Complex Problem Solving Question