1.
(a) The Consolidate function in LibreOffice Calc combines data from multiple ranges to create a single summary, often for analysis.
(b) What-if analysis explores the effects of changing input values on project outcomes.
(c) Goal Seek is a What-if analysis tool that determines the required input value needed to achieve a specific result.
2.
(a) Subtotal aggregates data within a range, while What-if analysis tests different scenarios.
(b)