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

