Solved

Match the Following Terms with the Corresponding Description

Question 100

Matching

Match the following terms with the corresponding description.

Premises:

Responses:

Solver

An add-in application that manipulates variables based on constraints to find the optimal solution to a problem

Variable

An input value that can change to other values to affect the results of a situation

Objective cell

Specifies the cell that contains a formula that produces a value that you want to optimize

Goal Seek

A tool that identifies the necessary input value to obtain a desired goal

Scenario Manager

Enables you to define and manage scenarios to compare how they affect results

Premises:

Solver

Variable

Objective cell

Goal Seek

Scenario Manager

Responses:

An add-in application that manipulates variables based on constraints to find the optimal solution to a problem

An input value that can change to other values to affect the results of a situation

Specifies the cell that contains a formula that produces a value that you want to optimize

A tool that identifies the necessary input value to obtain a desired goal

Enables you to define and manage scenarios to compare how they affect results

Correct Answer:

Premises:

Responses:

Solver

Variable

Objective cell

Goal Seek

Scenario Manager