Question

Define Subtotals b) Consolidating Data​

Answer 1

Answer:

Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.

hope it's helpful to you

Explanation:

Mark as brainliest answer

Answer 2

Answer:

a) Subtotals

Subtotal adds data arranged in an array—that is, a group of cells with labels for

columns and/or rows. It is available in Data Tab, using the Subtotals dialog, you

can select arrays, and then choose a statistical function such as Count, Min, Max

etc. to be applied on arrays. For efficiency, one must choose up to three groups

of arrays to which to apply a function.

b) Consolidating Data

Consolidate provides a graphical interface for copying data from one range

of cells to another, then running one of a dozen functions on the data.

During consolidation, the contents of cells from several sheets can be

combined in one place.

Explanation:

make it brainiest

thank u sure it will help u