What is goal seek in excel with example?
Answer / Sanmati Sindhu Raj
Goal Seek can be found under the 'Data' tab, then 'What-If Analysis', and finally by clicking on 'Goal Seek'. Here's an example: Suppose you have a formula calculating your monthly expenses based on the number of hours worked. If you want to find out how many hours you need to work to reach a specific monthly budget of $2000, you would set your target cell (the budget amount) and changing cell (hours worked), and then use Goal Seek to adjust the hours worked until the budget is reached.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the main features of ms excel 2007?
What is the shortcut to merge cells in excel?
What is excel database?
How to make a spreadsheet in excel 2007?
How do I copy and paste conditional formatting?
How can we use vlookup in excel?
What does ctrl f5 do in excel?
What is aggregate function in excel?
What is a conclusion in geometry?
How do I vlookup from another sheet in excel?
What are the different features of ms excel?
How do I combine text and formulas in excel?