Page 146 - IT_V1.0_Class10
P. 146

Sheet of District C












              To consolidate the data, follow these steps:
              Step 1:  Click on the Data menu.
              Step 2:  Select Consolidate option. A Consolidate window appears on the screen.
              Step 3:  Select desired function from the  Function box. The function specifies  how  the values of the
                      consolidation ranges are linked. The Sum is the default setting in Function drop down. Most of the
                      available functions are statistical (such as AVERAGE, MIN, MAX, STDEV).

              Step 4:  Click on the Shrink button next to Source data ranges area box.
              Step 5:  Select the cell range from the sheet to consolidate and click Shrink button again.

                                             1








                                                                                                                   3








                                                                                                                   4




                 2
















                           Select Cell
                             Range





                                                                                                        5





                144     Information Technology Play (Ver 1.0)-X
   141   142   143   144   145   146   147   148   149   150   151