A personalized and smart learning plan
Take a test on your terms and definitions
Scientifically backed study method
See how quickly you can match all your cards
Study terms and definitions
Tags & Description
View all (16)
New cards (16)
A program that can be added to Excel to provide enhanced functionality.
A constraint that solver enforces to reach the target value.
Changing variable cell
A cell containing a variable whose value changes until solver optimizes the value in the objective cell.
A limitation that imposes restrictions on a spreadsheet model as solver determines the optimum value for the objective
A tool that identifies the necessary input value to obtain a desired goal.
A constraint that does not restrict the target value that solver finds.
The cell that contains the formula-based value that you want to maximize, minimize, or set to a value in solver.
One-variable data table
A data analysis tool that provides various results based on changing one variable.
A model that finds the highest, lowest, or exact value for one particular result by adjusting values for selected variables.
A set of values that represent a possible situation.
A tool that enables you to define and manage scenarios to compare how they affect results.
Scenario summary report
A worksheet that contains the scenarios, their input values, and their respective results from using scenario Manager.
An add-in application that manipulates variables based on constraints to find the optimal solution to a problem.
A value that replaces the original value of a variable in a data table.
Two-variable data table
A data analysis tool that provides results based on changing two variables.
A value that you can change to see how that change affects other values.