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
   231   232   233   234   235   236   237   238   239   240   241