Page 145 - IT_V1.0_Class10
P. 145
Unit-2 ELECTRONIC SPREADSHEET (ADVANCED) USING LIBREOFFICE CALC
4 ANALYSE DATA USING
SCENARIOS AND GOAL SEEK
LibreOffice Calc is a powerful spreadsheet application that allows users to manage, analyse, and visualise
data. It offers a wide range of features, including data consolidation, scenario analysis, and goal-seeking
capabilities. Users can group and outline data, calculate subtotals, and perform what-if analysis to make
informed decisions. The application also includes advanced tools such as Goal Seek and Solver, which enable
users to find optimal solutions to complex problems. LibreOffice Calc versatility makes it a key tool for data
analysis and decision-making.
CONSOLIDATING DATA
Data consolidation refers to collecting and integrating data from multiple spreadsheets or sheets into a
single/master spreadsheet. During this process, the ‘Data Consolidation’ function takes data from a series of
sheets or spreadsheets and summarise it into a single spreadsheet.
This tool is most useful when you are working with the same data over and over.
Before consolidating data, ensure the following:
Open each sheet in the spreadsheet and verify that the data types you want to consolidate match.
Ensure the labels used for consolidation are consistent across all sheets.
Use the first column as the primary column for consolidating the data.
To consolidate data, we are using sheets for District A, District B, and District C, which contain the cell ranges
for the total consumption of drinks in the months of January, February, March, April, and May. Also, create a
sheet named Consolidate Data.
Sheet of District A
Sheet of District B
Analyse Data using Scenarios and Goal Seek 143

