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
   158   159   160   161   162   163   164   165   166   167   168