EX-K Q&A
add-in - (correct answer)An extra program, such as Solver and the Analysis ToolPak,
that provides optional Excel features. To activate an add-in, click the File tab, click
Options, click Add-Ins, then select or deselect add-ins from the list.
backsolving - (correct answer)A problem-solving method in which you specify a solution
and then find the input value that produces the answer you want; sometimes described
as a what-if analysis in reverse. In Excel, the Goal Seek feature performs backsolving
changing cells - (correct answer)In what-if analysis, cells that contain the values that
change in order to produce multiple sets of results.
constraints - (correct answer)Limitations or restrictions on input data in what-if analysis.
data table - (correct answer)A range of cells that shows the resulting values when one
or more input values are varied in a formula; when one input value is Changed, the
table is called a one-input data table, and when two input values are changed, it is
called a two-input data table. In a chart, it is a grid containing the chart data.
dependent cell - (correct answer)A cell, usually containing a formula, whose value
changes depending on the values in the input cells. For example, a payment formula or
function that depends on an input cell containing changing interest rates is a dependent
cell.
goal cell - (correct answer)In backsolving, a cell containing a formula in which you can
substitute values to find a specific value, or goal
goal seek - (correct answer)A problem-solving method in which you specify a solution
and then find the input value that produces the answer you want; sometimes described
as a what-if analysis in reverse; also called backsolving.
add-in - (correct answer)An extra program, such as Solver and the Analysis ToolPak,
that provides optional Excel features. To activate an add-in, click the File tab, click
Options, click Add-Ins, then select or deselect add-ins from the list.
backsolving - (correct answer)A problem-solving method in which you specify a solution
and then find the input value that produces the answer you want; sometimes described
as a what-if analysis in reverse. In Excel, the Goal Seek feature performs backsolving
changing cells - (correct answer)In what-if analysis, cells that contain the values that
change in order to produce multiple sets of results.
constraints - (correct answer)Limitations or restrictions on input data in what-if analysis.
data table - (correct answer)A range of cells that shows the resulting values when one
or more input values are varied in a formula; when one input value is Changed, the
table is called a one-input data table, and when two input values are changed, it is
called a two-input data table. In a chart, it is a grid containing the chart data.
dependent cell - (correct answer)A cell, usually containing a formula, whose value
changes depending on the values in the input cells. For example, a payment formula or
function that depends on an input cell containing changing interest rates is a dependent
cell.
goal cell - (correct answer)In backsolving, a cell containing a formula in which you can
substitute values to find a specific value, or goal
goal seek - (correct answer)A problem-solving method in which you specify a solution
and then find the input value that produces the answer you want; sometimes described
as a what-if analysis in reverse; also called backsolving.
