Question 1

Errors can be less obvious, introduced through formulas which, while technically correct, introduce unintended results to a worksheet.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Excel's data validation tool is a what-if analysis tool that allows you to record and save different sets of what-if assumptions used to forecast the outcome of a worksheet model.

Accepted Answer

A) True 
 B)False  False

Question 4

The ____ should be used before sharing a workbook publicly.

Accepted Answer

A)   Scenario Manager
B)   Document Inspector
C)   Information Manager
D)   Workbook Inspector

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used to manipulate one precedent cell to find a solution to a problem.

Accepted Answer

A)  formula auditing
B)  data validation
C)  constraint
D)  Scenario Manager
E)  precedentF) dependentG) Watch WindowH) circular referenceI) Goal SeekJ) Solver

Question 6

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a formula that validates the data entered by the user.

Accepted Answer

The answer of Among the various types of validation to...

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Allows you to monitor the values and formulas in cells as you work.

Accepted Answer

A)  formula auditing
B)  data validation
C)  constraint
D)  Scenario Manager
E)  precedentF) dependentG) Watch WindowH) circular referenceI) Goal SeekJ) Solver

Question 8

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 9

Which of the following are types of error styles?

Accepted Answer

A)   Stop
B)   Arrow
C)   Warning
D)   Information

Question 10

Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?

Accepted Answer

A)   Max Time
B)   Iterations
C)   Constraint Precision
D)   Use Automatic Scaling

Question 11

Briefly discuss three strategies for solving complex Excel problems.

Accepted Answer

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

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays prompts and error messages when users select a cell or enter invalid data.

Accepted Answer

A)  formula auditing
B)  data validation
C)  constraint
D)  Scenario Manager
E)  precedentF) dependentG) Watch WindowH) circular referenceI) Goal SeekJ) Solver

Question 13

To ensure that values in specific cells contain 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 14

Goal seeking allows you to manipulate multiple cells to find an optimal solution to a complex problem.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

Excel uses the Calculate Formulas button to move through a formula step by step.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is the path to the Solver button?

Accepted Answer

A)   (FORMULAS tab | Data Tools group) 
B)   (DATA tab | Analysis group) 
C)   (ANALYSIS tab | Data group) 
D)   None of the above

Question 18

Which of the following complex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?

Accepted Answer

A)   Trial and error method
B)   Solver feature
C)   Goal Seek feature
D)   Enable iterative calculations option

Question 19

Briefly explain the purpose of the Ignore blank check box in the Data Validation dialog box.

Accepted Answer

The answer of Briefly explain the purpose of the Ignore...

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A what-if analysis tool that allows you to record and save different sets of assumptions.

Accepted Answer

A)  formula auditing
B)  data validation
C)  constraint
D)  Scenario Manager
E)  precedentF) dependentG) Watch WindowH) circular referenceI) Goal SeekJ) Solver

Exam 10: Formula Auditing, Data Validation, and Complex Problem Solving

Errors can be less obvious, introduced through formulas which, while technically correct, introduce unintended results to a worksheet.

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

Excel's data validation tool is a what-if analysis tool that allows you to record and save different sets of what-if assumptions used to forecast the outcome of a worksheet model.

The ____ should be used before sharing a workbook publicly.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to manipulate one precedent cell to find a solution to a problem.

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a formula that validates the data entered by the user.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Allows you to monitor the values and formulas in cells as you work.

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

Which of the following are types of error styles?

Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?

Briefly discuss three strategies for solving complex Excel problems.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays prompts and error messages when users select a cell or enter invalid data.

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

Goal seeking allows you to manipulate multiple cells to find an optimal solution to a complex problem.

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

Excel uses the Calculate Formulas button to move through a formula step by step.

Which of the following is the path to the Solver button?

Which of the following complex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?

Briefly explain the purpose of the Ignore blank check box in the Data Validation dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A what-if analysis tool that allows you to record and save different sets of assumptions.