Question

define
i)subtotals
ii)consolidating data​

Answer 1

Explanation:

subtotal - is a fig. that is the result of adding some no. together but is not the final total.

consolidating data - allow YouTube gather together your data from separate worksheet into a master worksheet.

Answer 2

Answer:

a) subtotals

subtotal adds data arranged in an array -that is a groups of cells with labels for colums and / or rows it is available in data tab using the subtotals dialog you can select arrays and then choose a stasticle function such as count, min , max etc applied on arrays for efficiency one must choose up to three groups of arrays to which to apply a function

b) consolidating data

consolidating provides a graphical interface for copying data from one range of cells to another then running one of a dozen function on the data during consolidation the contents of cells from several sheets can be combined in one place

please mark me as brainlest plz