Machine-translated by Google. Questions are authored in English.
Top

Discussion

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

  • A.Goal Seek
  • B.Scenario Summary report
  • C.Forecasting
  • D.Trend line

Answer: D

Correct answer: Goal Seek

Goal Seek works backwards: you say what result you want from a formula and which cell may be altered, and Excel adjusts that cell until the formula produces it. A trend line is a chart annotation and does not change anything.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.