It collates the data from different ranges and places it in a worksheet.
a. Consolidate
b. Combining
c. Subtotals
most irrelevant answer will be marked brainliest
Answers
Answer:
combining is the right answer
Explanation:
it it means b part because combining collate the data from different ranges and place it in a worksheet
Answer:
The correct answer to the given question is:
a) Consolidate
Explanation:
Data consolidation allows you to gather your data from separate sheets into one master sheet. In other words, data consolidation pulls data from a series of spreadsheets or workbooks and summarizes it into a single spreadsheet that you can easily update.
Data Consolidation is an extremely useful tool to help you understand and present your data quickly and easily.
To start using the Data Merge tool, you must select a blank page in the workbook as the master sheet, or add a new sheet as needed. The workbook is renamed to "Consolidated Summary".
Merge data from multiple workbooks into a new workbook
Make sure that all the individual workbooks that you want to merge are now open.
Open a new blank workbook as the master sheet, or add a new workbook as needed. The sheet is renamed "Consolidated Summary" and saves this workbook with a name, for example, Summary.xls.
Select the top left cell of the area where you want the aggregated data to appear.
On the ribbon select Data > Merge to bring up the Merge dialog
Now we proceed as we did in the first example, the only difference is that we are selecting a range of data from different workbooks instead of different worksheets.
When you click OK, Excel summarizes all the data in your new master worksheet.
#SPJ3