Page 191 - Trackpad 402_Class-X_Final
P. 191
UNIT Electronic Spreadsheet
2 (Advanced)
Topics Covered 95%
Data Consolidation Creating Subtotals
Using WHAT-IF Scenarios Goal Seek Analysis
Using Solver Linking Data and Worksheets
Cell Reference Working with Hyperlinks in a Sheet
Sharing Worksheet Data Record Changes in a spreadsheet
Adding Comments to Changes Merging Worksheets
Comparing Documents What are Macros?
Data analysis is an important part of many professional places. It is required to study the trends of products required
in the local and global market. It is an important part of many organization for planning and taking important decisions
for the progress of the company. The important data analysis tools available in OpenOffice spreadsheet are Data
Consolidation, What-if Analysis, Goal Seek and many more. In this unit we will study about these important data
analysis tools.
DATA CONSOLIDATION
Data consolidation means to collect data from different sources into a common place by using different built in
functions like sum(), max(), min(), average(), etc. Data consolidation is used for data collection so that data analysis
can easily be done. The data of similar type from different sheets in the same workbook is picked up, consolidated and
saved for further data analysis.
Let us take an example of adding the marks of weekly test, half yearly and finals stored in three different sheets in the
same workbook so that the consolidated marksheet of a student can be generated.
The steps to consolidate data are as follows:
Step 1: Create sheet1-weekly test, sheet2-half yearly and sheet3-finals in Final Result.ods.
Step 2: Select the range B3:B8 in the ‘weekly test' sheet.
Electronic Spreadsheet (Advanced) 191

