Question

Which one of the following is the default function when a Consolidate dialogue box opens in LibreOffice Calc?

Options

• Average

• Sum

• Max

• Var

Answer 1

Sum

Explanation:

Data consolidation is typically used to combine and total information from multiple ranges or sheets. Since addition is the most common way to aggregate this data, Sum is set as the standard starting function for the user.