1 / 10

Presentation of PC Software Topic-Goal Seek

Presentation of PC Software Topic-Goal Seek. Submitted to: Hina mam (lect. of comp’s department) Submitted by: Rajnesh 1615801 B.Voc (SD) 1st. Goal Seek:.

pcroteau
Download Presentation

Presentation of PC Software Topic-Goal Seek

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Presentation of PC SoftwareTopic-Goal Seek Submitted to: Hina mam (lect. of comp’s department) Submitted by: Rajnesh 1615801 B.Voc (SD) 1st

  2. Goal Seek: Goal seeking is the ability to calculate backward to obtain an input that would result in a given output .This can also be called what-if analysis and back-solving. or The process of finding the correct input when only the output is known.

  3. To perform this task ,from the Tools menu use the Goal Seek command. Now,we want to calculate the value of C2 when we assume the sum takes a value 270.We will do this by Goal Seek. The following steps will be performed:

  4. 1.Select the cell in which formula is being applied .That cell will be highlighted.

  5. 2.Click at Goal Seek command in the Tool menu .A goal seek dialog box will be displayed on the screen.

  6. Now click on expand button on the goal seek dialog box option and return on the cell option .The cell in the set cell box should have a formula in it.

  7. 3.Now write the new value you want for the cell in To Value :text box.4.Click By changing cell

  8. Click OK button in the dialog box.

  9. The changes would be seen in the worksheet and dialog box will be appear.

  10. THANK YOU

More Related