Many people think they need extensive formulas in Excel to display specific parts of their data. But, usually this can be accomplished much easier by simply applying filters. And most of what you want to do can be achieved with Excel’s AutoFilter command.
Why we can use goal seek in microsoft excel?
What is the purpose of use in microsoft excel?
Please reply.
HELLO NITIKA,
I HAVE ANSWER OF ALL THE QUESTIONS U HAVE POSTED.
FIRST WHAT IS GOAL SEEK?
GOAL SEEK IS USED WHEN WE HAVE A RESULT AND WANTED TO CHANGE THAT TO THE DESIRED RESULT.
TAKE A EXAMPLE OF THE SUM OF TWO NO. SUPPOSE U HAVE A TOTAL OF 5 IN C1 CELL WHEN 2 IS PLACED IN BOTH THE PREVIOUS CELLS.
AND NOW U WANT TO CHANGE THE TOTAL TO 7 BY CHANGING THE CELL A1 AND DOES NOT KNOW WHAT WILL BE THE VALUE WHICH WILL BRING THE DESIRED RESULT.
AT THIS STAGE THE GOAL AND SEEK OPTION WILL HELP.
THIS WILL ASK THE VALUE U NEED AND THE CELL U WANT TO CHANGE FOR THE DESIRED RESULT.
IF U STILL HAVE A PROBLEM I WILL SOON POST A CHAPTER ON GOAL SEEK PLEASE GO THROUGH THAT ONE.
AND REMAINING QUESTIONS WILL BE ANS LATER.
Post Comments
nitikagoyal said – Fri, 25 Jul 2008 05:57:06 -0000 ( Flag Edit Link )
What is the pivot table and pivot chart report in mirosoft excel?