Question

Which of the following feature of excel will you use to collate the data of several worksheets into a master worksheet​

Answer 1

Answer:

Hey mate,here's your answer

Explanation:

To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet, or in other workbooks. When you consolidate data, you assemble data so that you can more easily update and aggregate as necessary.

For example, if you have an expense worksheet for each of your regional offices, you might use consolidation to roll these figures into a master corporate expense worksheet. This master worksheet might also contain sales totals and averages, current inventory levels, and highest selling products for the entire enterprise.

Hope it's helpful.

Please mark me as brainlist.

Answer 2

Answer:

How to collect data from multiple sheets to a master sheet in...

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

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

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