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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Finds solutions by evaluating many combinations of constrained cell values.

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

Tracing _________________________ in Excel allows you to see the cells on which a formula is based.

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

You can attempt to solve a complex worksheet problem manually, also known as the trial and error method.

Which of the following is the path to the 'What-If Analysis' button?

Briefly discuss setting iterative calculation options.

Case 9-1 You are presenting a two-hour seminar on using Excel features to professionals at an annual convention of accounting managers. The seminar will be followed by a brief Q&A session. Half-way through the seminar, you give the seminar participants a break. -During the following Q&A session, another participant complains that a workbook created in his accounting department was widely shared with others in his company; unfortunately, the workbook contained sensitive information in hidden rows and columns that should not have been shared. He asks if Excel has a feature that can help to prevent this problem in the future. You tell him to ____.

Which of the following are error codes?

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

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

The Scenario Manager command is located on the ____ menu.

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

The Add Watch button is located on the _________________________ toolbar.

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 conditions specified for data validation.

Case 9-2 Once each month, the accounting staff meets in the conference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting covers a few of Excel's advanced features. As the senior accountant and most experienced Excel user in the department, you have volunteered to mediate the discussion. -Mel, who develops budgets and financial forecasts, asks you to explain the difference between using Goal Seek and Solver to find solutions to complex worksheet projections. You tell Mel that ____.

When using the Custom data validation type, you can use a formula that evaluates to either true or false.

A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.

Changing cells or adjustable cells are the cells modified by __________________________ to solve a problem.

Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.