Matching
Match the following terms with the corresponding description.
Premises:
Goal Seek
Solver
Scenario Manager
Variable
Objective cell
Responses:
An add-in application that manipulates variables based on constraints to find the optimal solution to a problem
A tool that identifies the necessary input value to obtain a desired goal
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
Enables you to define and manage scenarios to compare how they affect results
Correct Answer:
Premises:
Responses:
Goal Seek
Solver
Scenario Manager
Variable
Objective cell
Premises:
Goal Seek
Solver
Scenario Manager
Variable
Objective cell
Responses:
Related Questions
Q25: Match the following terms with their meanings:
Q26: What is the purpose of adding an
Q27: Match the following action buttons to the
Q28: The _ function checks if a field
Q29: Explain the difference between a lookup list
Q31: [Enter city] on the criteria line of
Q32: Match the following terms with their meanings:
Q33: A(n)_ performs calculations on an entire column
Q34: When building a table,you can set up
Q35: Which data validation property specifies a value