Question

________________ allows you to gather together your data from separate worksheets

into a master worksheet.​

Answer 1

Answer:

1. In a new sheet of the workbook which you want to collect data from sheets, click Data > Consolidate.

2. In the Consolidate dialog, do as these: (1 Select one operation you want to do after combine the data in Function drop down list; Click.

3. Click OK. Now the data have been collect and sum in one sheet.

Answer 2

Data consolidation

Data consolidation allows you to gather together your data from separate worksheets into a master worksheet.​

• Excel might be used, for instance, in a budgeting scenario to gather budget data from many departments and then combine the data into a single overall group or business budget.
• The Excel data consolidation tool enables you to combine data from different workbooks into a single spreadsheet.
• A crucial phase in the integration and data management processes is data consolidation.
• With all data in one location, productivity and efficiency are increased since it makes all data management information immediately and easily accessible.
• You can combine data from each worksheet into a master worksheet to summarize and report results from other worksheets. The worksheets may be located in other workbooks or in the same workbook as the master worksheet. By assembling data, you can more readily update and combine it as needed when you consolidate data.

#SPJ3