What is goal seek in excel with example?



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

Post New Answer

More MS Excel Microsoft Interview Questions

What are the main features of ms excel 2007?

1 Answers  


What is the shortcut to merge cells in excel?

1 Answers  


What is excel database?

1 Answers  


How to make a spreadsheet in excel 2007?

1 Answers  


How do I copy and paste conditional formatting?

1 Answers  


How can we use vlookup in excel?

1 Answers  


What does ctrl f5 do in excel?

1 Answers  


What is aggregate function in excel?

1 Answers  


What is a conclusion in geometry?

1 Answers  


How do I vlookup from another sheet in excel?

1 Answers  


What are the different features of ms excel?

1 Answers  


How do I combine text and formulas in excel?

1 Answers  


Categories