Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 71 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 71

    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.

                                                                                         Advanced Features of Calc       69

| 66 67 68 69 70 71 72 73 74 75 76 |