Answer:
2. Go to the Data tab on the ribbon and select Data Tools.
3. Then, select and the dialog box will appear.
4. Choose the in the drop-down. Then, select the first group of data and press Enter.
1. Select the range of data on the first worksheet you wish to consolidate.
5. To add from more worksheets, select from the View tab.
Explanation:
Consolidation in Microsoft Excel is used to gather information from several worksheets. To consolidate data in a new worksheet, select the new worksheet and click on the upper left side where the data should be.
Click on Data > Consolidate, then a dialog box would appear. From the dialog box click on the function to consolidate with, then click on the reference area and select the first data range by clicking on the first worksheet and drag the data range to the box and click Add.
To add more data range, click on the reference area and do the same as the first data.
