He enters his estimated marks for Physics, Chemistry and Math in the worksheet cells B1, B2 and B3 with labels on the left in cells A1, A2 and A3. He now uses Goal Seek to estimate his chance of getting a seat in an engineering college based on his estimated performance, experience of scoring in English and the minimum marks required to get a seat. He knows from past experience that inspite of hard and smart work he has never been able to score more than 80. Now he has to take his last exam in English. ![]() He estimates that he may have scored certain marks in Physics, Chemistry and Math. Let’s take, for example, a student who participates in an engineering entrance examination. Goal seek is used to find an input value if you know the final result and therefore very useful. ![]() What is Goal seek? Goal Seek is part of Microsoft Excel’s What-If analysis tools.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |