Page 147 - IT_V1.0_Class10
P. 147

Step 6:  Click on Add button to insert the selected range in the Consolidation ranges field.

                 Step 7:   Select additional ranges from different sheets and then click the Add button for each selection.
                 Step 8:    Click on the Shrink button next to Copy results to, to select the target cell range to display the
                         consolidated data from the above selected sheets’ data.












                                                                                                                      7

                                                                                                                      8
                                                                 6




                 Step 9:      Click on Options button. This will show Consolidate by including: Row labels and Column labels
                          check box and Options including Link to source data check box.

                 Step 10:  Select Link to source data check box to update the values in the target cell range with respect to the
                          change in source cell range values. If you link the data, any values modified in the source range are

                          automatically updated in the target range. The corresponding cell references in the target range are
                          inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the
                          final result, based on the selected function, is displayed.

                 Step 11:  Click on OK button to consolidate the ranges.










                                                                                                  Consolidated Data



                         9
                                               11
                                10




                 The data from the consolidation ranges and target range are saved when you save the sheet. If you later open
                 a sheet in which consolidation has been defined, this data will again be available.
                             Notes

                            Row labels or Column labels are used when the cells of the source data range are to be consolidated
                            as per the matching row label or column label but not corresponding to the identical position of the
                            cells in the range. However, the labels must be identical.



                                                                        Analyse Data using Scenarios and Goal Seek   145
   142   143   144   145   146   147   148   149   150   151   152