Question 1

Dashed precedent arrows, as shown in the acsampanying figure, indicate precedents on _________________________.

Accepted Answer

The answer of  Dashed precedent arrows, as shown in...

Question 2

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

Question 3

The ____ feature is especially useful when working with very large worksheets.

Accepted Answer

A)  model 
B)  summary 
C)  outline 
D)  auditing

Question 4

The goal for the Solver feature is to maximize the solution within the sanstraints set.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

Accepted Answer

A)  precedents 
B)  dependents 
C)  examples 
D)  relationships

Question 7

Entries that are the result of calculations will not produce data validation errors.

Accepted Answer

A) True 
 B)False

Question 8

The _________________________ feature does have some characteristics that require that you stay vigilant when using it; it may, for example, find a solution that satisfies the criteria specified but that violates sanditions specified for data validation.

Accepted Answer

The answer of The _________________________ feature does have some characteristics...

Question 9

The Show Iteration Results check box is located in the ____ dialog box.

Accepted Answer

A)  Goal Seek solution 
B)  Data Validation Rules 
C)  Add Scenarios 
D)  Solver Parameters

Question 10

_________________________ is a samplex mathematical process used to solve problems that include multiple variables.

Accepted Answer

The answer of _________________________ is a samplex mathematical process used...

Question 11

An Answer Report shows original and final values of the target cell and changing cells plus ____.

Accepted Answer

A)  cell formatting 
B)  sanstraints 
C)  previous trial and error solutions 
D)  all scenarios

Question 12

Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____ Report shows the answer that Solver found, which sanstraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those sanstraints.

Accepted Answer

A)  Solution 
B)  Resolution 
C)  Answer 
D)  Calculation

Question 14

Which of the following actions can you perform using data validation rules?

Accepted Answer

A)  place restrictions on values 
B)  provide a message to the user

Question 15

A cell santaining a formula that references other cells is said to have ____.

Accepted Answer

A)  dependents 
B)  calculations 
C)  precedents 
D)  references

Question 16

To ensure that values in specific cells santain only nonnegative whole numbers, Scenario Manager rules should be applied to those cells to restrict a user from entering invalid data.

Accepted Answer

A) True 
 B)False

Question 17

For each model, it is helpful to define a ____ scenario that represents the starting assumptions.

Accepted Answer

A)  baseline 
B)  topline 
C)  bottomline 
D)  sideline

Question 18

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

A) True 
 B)False

Question 19

Briefly discuss three strategies for solving samplex Excel problems.

Accepted Answer

The answer of Briefly discuss three strategies for solving samplex...

Question 20

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

Accepted Answer

A)  Show Window 
B)  Data Window 
C)  Watch Window 
D)  Calculation Window

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

Dashed precedent arrows, as shown in the acsampanying figure, indicate precedents on _________________________.

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

The ____ feature is especially useful when working with very large worksheets.

The goal for the Solver feature is to maximize the solution within the sanstraints set.

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

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

Entries that are the result of calculations will not produce data validation errors.

The _________________________ feature does have some characteristics that require that you stay vigilant when using it; it may, for example, find a solution that satisfies the criteria specified but that violates sanditions specified for data validation.

The Show Iteration Results check box is located in the ____ dialog box.

_________________________ is a samplex mathematical process used to solve problems that include multiple variables.

An Answer Report shows original and final values of the target cell and changing cells plus ____.

Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula.

A(n) ____ Report shows the answer that Solver found, which sanstraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those sanstraints.

Which of the following actions can you perform using data validation rules?

A cell santaining a formula that references other cells is said to have ____.

To ensure that values in specific cells santain only nonnegative whole numbers, Scenario Manager rules should be applied to those cells to restrict a user from entering invalid data.

For each model, it is helpful to define a ____ scenario that represents the starting assumptions.

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.

Briefly discuss three strategies for solving samplex Excel problems.

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.