Question

The tool used to reverse the
usual order for a formula is
a) Data
b) Goal Seek
c) Tools
d) Apply​

Answer 1

Answer:

The relevant answer to this query is an option b) Goal seek.

The tool used to reverse the usual order for a formula is Goal seek.

Explanation:

• The Goal Seek Excel function( frequently appertained to as What- if- Analysis) is a system of working for the asked output by changing the supposition that drives it.
• The function basically uses a trial and error path to back-breaking the problem by plugging in suppositions until it arrives at the answer.

• For illustration, if the formula for revenue is the same as the number of units retailed multiplied by the selling cost,
• Goal Seek can determine how numerous units have to be retailed to pass$ 8 million of profit if the selling cost is known.
• The function is extremely applicable for performing perceptivity analysis in monetary modeling.

#SPJ2

Answer 2

The tool used to reverse the usual order for a formula is option b - goal seek.

Goal seek:

• Goal seeking is the process of calculating in reverse to find the right method when only the desired outcome is known.
• When just the output is known, goal seeking is the process of determining the proper input value.
• Different types of computer software, like Microsoft Excel, can provide the ability to set goals.
• One of the strategies used in "what-if analysis" of computer software applications is goal seeking.
• The technique of modifying values in (Microsoft Excel) cells to evaluate how these changes may affect formula results on the worksheet is known as a "what-if analysis."
• You execute what-if analysis on a given value, or the outcome, when you are goal seeking.
• So, by asking "what if the outcome was X," you would essentially be establishing a cause-and-effect scenario.

#SPJ