Page 163 - IT 402 v2.0 class 10
P. 163
Step 10: lick on More button and then click on ink to source data checkbox. ink to source data option
is used to update the values in the target cell range with respect to the change in source cell range
values.
Step 11: lick on O button to consolidate the ranges.
11
Consolidated
Data
N ot e s
Row labels or Column labels are used when the cells of the source data range are to be consolidated
R ow labels or Column labels are used when the cells of the source data range are to be consolidated
Column labels
not
sponding
corre
corre
not
label
column
column
but
but
label
sponding
of
position
position
the
the
of
the
to
to
identical
identical
the
the
per
matching
the
as
as per the matching row label or column label but not corresponding to the identical position of the
per
as
matching
row
row
label
or
or
label
cells in the range. owever the labels must be identical.
cells in the range. owever the labels must be identical.
cells in the range. owever the labels must be identical.
Sneak Peek
To Consolidate Data in Microsoft Excel:
. lick on the ata tab. lick on onsolidate option in the ata command group.
onsolidate dialog box appears on the screen.
. hoose the desired Function and eference for the data.
. lick on op row eft column and reate links to source data check box.
. lick on O button.
Advanced Features of Spreadsheet 161

