Home > Preview
The flashcards below were created by user
davecowman
on FreezingBlue Flashcards.

Variable (p. 378)
A value that can change to see how that change affects other values.

WhatIf Analysis (p. 378)
The process of changing variables to observe how changes affect calculated results.

OneVariable Data Table (p. 378)
A data analysis tool that provides various results based on changing one variable.

TwoVariable Data Table (p. 382)
A data analysis tool that provides results based on changing two variables

Goal Seek (p. 389)
A tool that identifies the necessary input value to obtain a desired goal.

Scenario (p. 390)
A set of values that represent a possible situation.

Scenario Manager (p. 390)
Enables you to define and manage scenarios to compare how they affect results.

Scenario Summary Report (p. 392)
A worksheet that contains scenario results.

AddIns (p. 398)
A program that can be added to Excel to provide enhanced functionality

Optimization models (p. 398)
Finds the highest, lowest, or exact value for one particular result by adjusting values for selected variables.

Objective Cell (p. 399)
The cell that contains the formulabase value that you want to maximize, minimize, or set to a value in Solver.

Changing variable cells (p. 399)
A cell containing a variable whose value changes until Solver optimizes the value in the objective cell.

Constraints (p. 400)
A limitation that imposes restrictions on Solver.

Binding Constraint (p. 402)
A constraint that Solver enforces to reach the target value.

Nonbinding constraint (p. 403)
A constraint that does not restrict the target value that Solver finds.

