Page 162 - IT 402 v2.0 class 10
P. 162
onsolidate window appears on the screen.
Step 3: lick on the Source ata ange area box. blinking cursor will appear in the box.
Step 4: Select a source cell range from the worksheet to consolidate with other areas.
3
4
Step 5: lick on dd button to insert the selected range in the onsolidation ranges field.
Add Consolidation
Range
5
6
Step 6: Select additional ranges from different worksheets and then click the dd button again for each
selection.
Step 7: lick on the opy results to area box. blinking cursor appears in the box.
Step 8: Select a target cell range in which all the data are re uired to be consolidated.
8
7
10
Step 9: Select desired function from the Function box. he function specifies how the values of the
consolidation ranges are linked. he Sum function is the default setting.
160 Touchpad Information Technology-X

