Solved

Match the Following Terms with the Corresponding Description

Question 10

Matching

Match the following terms with the corresponding description.

Premises:
Objective cell
Variable
Solver
Scenario Manager
Goal Seek
Responses:
A tool that identifies the necessary input value to obtain a desired goal
Specifies the cell that contains a formula that produces a value that you want to optimize
Enables you to define and manage scenarios to compare how they affect results
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

Correct Answer:

Objective cell
Variable
Solver
Scenario Manager
Goal Seek
Related Questions

Q5: Comments can be added to Scenarios in

Q6: Match the following terms with the corresponding

Q7: Scenario Manager is an Excel add-in.

Q8: Two reference formulas are required to complete

Q9: Solver can solve linear and nonlinear problems.

Q11: Scenario summary reports update when input cells

Q12: _ has the ability to generate Answer

Q13: Which of the following tools can manipulate

Q14: Which of the following calculations on the

Q15: Match the following terms with the corresponding