Question

What is the function of Consolidate option in OpenOffice Calc?​

Answer 1

Answer:

Data > Consolidate provides a way to combine data from two or more ranges of cells into a new range while running one of several functions (such as Sum or Average) on the data. During consolidation, the contents of cells from several sheets can be combined in one place.

Answer 2

Answer:

List of Calc 'Spreadsheet' functions

List of Calc 'Spreadsheet' functionsThe so-called 'Spreadsheet' functions find values in tables, or cell references; they include LOOKUP, SEARCH, ADDRESS. They could thus also be described as 'Lookup' functions.

List of Calc 'Spreadsheet' functionsThe so-called 'Spreadsheet' functions find values in tables, or cell references; they include LOOKUP, SEARCH, ADDRESS. They could thus also be described as 'Lookup' functions.Spreadsheet Lookup functions

List of Calc 'Spreadsheet' functionsThe so-called 'Spreadsheet' functions find values in tables, or cell references; they include LOOKUP, SEARCH, ADDRESS. They could thus also be described as 'Lookup' functions.Spreadsheet Lookup functionsADDRESS returns a text representation of a cell reference, given row and column numbers.