Page 236 - Trackpad 402_Class-X_Final
P. 236
3. The ‘Subtotal’ dialog box will appear on the screen. Click the drop-down arrow for the ‘At each
change in’ and select the desired field.
4. Click the drop-down arrow for the ‘Use function’ field to select the desired function.
5. In the ‘Add subtotal to’ field, select the desired column and then click on ‘OK’ button.
III Using Goal Seek in Microsoft Excel:
1. Select the cell that contains a formula.
2. Click on ‘Data’ tab and then click ‘What-If Analysis’ command from ‘Data Tools’ command group.
Select ‘Goal Seek’ option from the drop-down menu.
3. A dialog box will appear with three fields:
Set cell: This is the cell that contains the desired result.
To value: This is the desired result.
By changing cell: This is the cell where Goal Seek places its answer.
4. Set appropriate values and then click on ‘OK’ button.
236 Trackpad Information Technology-X

