Question

Q. 18 Define the following:
a) Subtotals
b) Consolidating Data​

Answer 1

Answer:

Subtotal - The total of one set of a larger group of figures to be added.

Consolidating Data - Data consolidation is the corralling, combining, and storing of varied data in a single place. ... The term sometimes is used interchangeably with data integration. Data consolidation enables businesses to streamline their data resources, discover patterns, and look for insights in multiple types of data.

Explanation:

mark as brainlist

Answer 2

Answer:

a) Subtotals

b) Consolidating Data​

Explanation:

Subtotal: The SUBTOTAL function is intended for vertical ranges or columns of data.

It is not intended for horizontal ranges or rows of data.

For instance, suppressing a column has no effect on the subtotal when you subtotal a horizontal range using a function num of 101 or more, as SUBTOTAL(109,B2:G2).

The word "total" refers to the overall, total sum of all other sets of numbers or subtotals.

The total of one group of numbers that will subsequently be added to another set is described by the term "subtotal" in contrast.

To display a calculation that is a component of a bigger total, subtotals are utilized.

Consolidating Data​:The process of gathering all of your data from many sources across your organization, cleaning it up, and consolidating it in one place, such a cloud data warehouse or lake house environment, is known as data consolidation.

Excel might be used, for instance, in a budgeting scenario to gather budget data from many departments and then combine the data into a single overall group or business budget.

The Excel data consolidation tool enables you to combine data from different workbooks into a single spreadsheet.

#SPJ2