Page 156 - Computer - 10(A&B)

Step 2: On the Data menu, click on Consolidate option. The Consolidate dialog box opens.

Step 3: Choose a function from the Function list. The function specifies how the values of the consolidation
ranges are linked. The Sum function is the default setting.
Some of the available functions are Sum, Product, Average, Min, Max, and Count.
Step 4: If the Source data range list contains named ranges, you can select a source cell range to consolidate
with other areas.
If the source range is not named, click on the Shrink button. The Consolidate Source data range dialog
box opens.
Step 5: Type a reference for the first source data range or use the mouse to select the range on the sheet. Then,
click on the Expand button to go back. Select the range A1:F6 in the Term 1 worksheet.
Step 6: Click on Add button. The selected range now appears on the Consolidation ranges list.

Shrink Button

Step 7: Select additional ranges A1: F6 in the Term 2 worksheet and click on Add button after each selection.

38