Question

Define
Solver
Goal seek
Consolidation
Acc. To 2 marks.

Answer 1

Answer:

Goal Seek determines what value needs to be in an input cell to achieve a desired result in a formula cell. Solver determines what values need to be in multiple input cells to achieve a desired result. We are going to learn to use both the Goal Seek and Solver tools in this article.