Question

Define the following:

a) Subtotals

b) Consolidating Data​

Answer 1

friend this is your answer.

SUBTOTAL- can return a SUM, AVERAGE, COUNT, MAX, and others (see table below), and SUBTOTAL function can either include or exclude values in hidden rows.

consolidation-the act or process of consolidating : the state of being consolidated. 2 : the process of uniting : the quality or state of being united specifically : the unification of two or more corporations by dissolution of existing ones and creation of a single new corporation.

hope this is helpful thanks

please mark me as BRAINLIST