Computer Concepts Chapter 9

Which of the following is NOT an issue that must be kept in mind when using Solver?

Constraint precision is incompatible with most forms of automatic scaling

The Trace Error button is located in the ____ dialog box.

Error Checking

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. True or False

False

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

False

The error code #DIV/0! indicates that there are no common cells in two ranges a formula identifies as having an intersection. True or False

False

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

Iterations

One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

Solver

Errors can be introduced into a worksheet in formulas. True or False

True

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

True

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

auditing

When a cell contains a(n) ____ reference, it means that one of its defining values is itself.

circular

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.

dependents

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

precedents