Question

Write steps to use consolidating data in OO Calc.​

Answer 1

Answer:

During consolidation, the contents of cells from several sheets can be combined in one place. Open the document that contains the cell ranges to be consolidated. Choose Data > Consolidate to open the Consolidate data

Answer 2

Answer:

Explanation:

1) Open the document that contains the cell ranges to be consolidated.

2) Choose Data > Consolidate to open the Consolidate dialog

3) If the Source data range list contains named ranges, you can select a source

cell range to consolidate with other areas

4) Click Add. The selected range now appears on the Consolidation ranges list.

5) Select additional ranges and click Add after each selection.

6) Specify where you want to display the result by selecting a target range from the Copy

results to box.

7) Select a function from the Function list such as AVERAGE, MIN, MAX, STDEV.

8) Optionally click more in the Consolidate dialog to display additional settings.

Select Link to source data, Under Consolidate by, select either Row labels or Column

Labels.

9) Click OK to consolidate the ranges.