Question

allows you to gather together your data from separate worksheets
into a master worksheet.
a) Goal Seek
b) Scenario
c) Data Consolidation d) Subtotal​

Answer 1

Answer:

data consolidation

Answer 2

Data Consolidation allows you to gather

together your data from separate worksheets into a master worksheet.

• MS Excel offers a feature of data consolidation through which one can put data from different worksheets into a single master worksheet.
• While goal seek refers to the process of back solving.
• The scenario feature offers Excel users to store multiple types of data in a single cell.
• The subtotal option yields the aggregate result of a given set of values.