Discussion
In MS Excel, the Goal Seek tool is used to
Answer: A
Correct answer: find the input value needed to produce a desired formula result
Goal Seek, under What-If Analysis on the Data tab, works a calculation backwards: given a formula and a target result, it finds the input value that produces it. It takes three arguments - the cell containing the formula, the value it should reach, and the single cell to change - and then adjusts that cell iteratively until the target is met. A typical use is finding the sales figure needed to hit a profit target, or the interest rate that gives a required repayment. Its limits define when to use something else. It changes exactly one input, the changing cell must be a constant rather than a formula, and it finds an approximate numerical solution rather than an exact algebraic one. For several inputs at once, or for constraints and an optimum rather than a target, the Solver add-in is the tool. Data Tables and Scenario Manager, on the same menu, explore what happens when inputs vary rather than solving for one.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development