Page 245 - Trackpad 402_Class-X_Final
P. 245
III Using Goal Seek in LibreOffice Calc:
1. Click on ‘Tools’ menu.
2. Select ‘Goal Seek’ option. Goal Seek’ dialog box appears on the screen.
3. The Goal Seek dialog box will appear. The cell address containing the formula is already entered in a
‘Formula cell’ field. Enter the Target value and Variable cell.
4. ‘Place the cursor in the ‘Variable cell’ field. In the sheet, click in the cell that contains the value to be
changed.
5. Click on OK button. The LibreOffice Calc dialog box will appear.
6. Click on Yes button.
Electronic Spreadsheet (Advanced) 245

