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.