Page 160 - IT 402 v2.0 class 10
P. 160
Unit-2 Electronic Spreadsheet (Advanced)
ADVANCED FEATURES OF SPREADSHEET 2
Data is one of the most important sources for analysing or getting proper information. Generally,
while working in o ce we get data under different fields but this data may be related to each
other.
Such data is kept in numerous worksheets but it is useful when the related data can be compared
edited or manipulated. It becomes necessary to merge different data into single sheet. Spreadsheet
package is of great help in sharing merging referencing hyperlinking consolidating etc.
CONSOLIDATING DATA
ata consolidation refers to collecting and integrating data from multiple worksheets or workbooks
into a single/master worksheet.
uring this process the ata onsolidation function takes data from a series of worksheets or
workbooks and summarise it into a single worksheet.
To Combine Cell Contents
Open the worksheet of istrict istrict and istrict which contains the cell ranges to be
consolidated.
Worksheet of District A
158 Touchpad Information Technology-X

