Page 146 - IT_V1.0_Class10
P. 146
Sheet of District C
To consolidate the data, follow these steps:
Step 1: Click on the Data menu.
Step 2: Select Consolidate option. A Consolidate window appears on the screen.
Step 3: Select desired function from the Function box. The function specifies how the values of the
consolidation ranges are linked. The Sum is the default setting in Function drop down. Most of the
available functions are statistical (such as AVERAGE, MIN, MAX, STDEV).
Step 4: Click on the Shrink button next to Source data ranges area box.
Step 5: Select the cell range from the sheet to consolidate and click Shrink button again.
1
3
4
2
Select Cell
Range
5
144 Information Technology Play (Ver 1.0)-X

