Question

make the total from 180 to 200 by increasing the no of si by using "goal seek method" write down the steps​

Answer 1

Answer:

1. Place the cursor in the formula cell (D2)

2. Click Tools -> Goal Seek -> A dialog box appears

3. Formula cell option shows the selected formula cell D2

4. In Target Value specify the desired result of the formula to be achieved via Goal Seek. Here, 200

5. In Variable Cell click in the sheet cell that contains the value to be changed like A2 -> click OK

It will show the targeted simple interest of 200 by changing the value of Principal amount.