. __________is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet
Answers
Answered by
26
Answer:
Ooo
Explanation:
Solver is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet
Answered by
0
Solver is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.
Definition of Solver
- What-if analysis may be done with Solver, a Microsoft Excel add-in tool.
- The Excel Solver tool is on the Data Ribbon, and the Windows keyboard shortcut is Alt, A, Y 21.
- When the dialogue box displays, you'll have a number of alternatives to choose from.
Working of solver
- Solver uses a set of cells known as choice variables, or simply variable cells, to compute the formulae in the objective and constraint cells.
- Solver modifies the values of choice variable cells to fulfill constraint cell restrictions and generate the desired outcome for the goal cell.
Hence, solver is used to minimize or maximize the result according to a set of rules.
#SPJ3
Similar questions