________ allows you to gather data from different worksheets into a master worksheet.AGoal SeekBTotal dataCSolverDData Consolidation

The correct answer to the question “________ allows you to gather data from different worksheets into a master worksheet” is:

D. Data Consolidation

Data Consolidation in Excel is a powerful feature that enables users to compile data from multiple worksheets into a single master worksheet. This is particularly useful when working with large datasets or when information is spread across various tabs within a workbook. By using Data Consolidation, you can summarize data, perform calculations, and analyze consolidated results more efficiently.

Explanation of Options:

1. Goal Seek: This tool is used for finding the input values needed to achieve a specific goal in a formula.
2. Total Data: This is not a recognized feature in Excel related to data gathering.
3. Solver: This is a tool used for optimization, helping to find the best solution for a problem based on constraints.

Thus, Data Consolidation is the appropriate choice for this context.