Which feature is used to summarize data from multiple worksheets but does not require that the data be in the same location on every worksheet?

Respuesta :

Consolidate data from each worksheet into a single worksheet to summarize and report results from several worksheets.

What is worksheet?

A group of cells arranged into rows and columns is referred to as a "worksheet" in Excel documents.

Data consolidation makes it possible to combine the information from various worksheets into one master worksheet.

In other words, the Data Consolidation function compiles information from a number of worksheets or workbooks into a single worksheet that you can quickly update.

As a result, data consolidation is summarizing data from multiple worksheets.

Learn more about on worksheets, here:

https://brainly.com/question/2554742

#SPJ1