Question

Explain purpose and steps for using goal seek and solver, with example, in Libreoffice

Calc​

Answer 1

Answer:

To use Goal Seek: Fill the cell with the unknown data with a 0 (or any other value). Select the cell containing the Formula (in our example the Average grade) and Choose Tools > Goal Seek from the main menu. In the Goal Seek dialog window fill in the parameters.