Question

2. In order to consolidate the data from different parts of the same sheet, use:
(a) Sum option
(b) Average function
(c) Consolidate option​

Answer 1

Answer:

consolidate option

Explanation:

please mark as brainlest answer please mark

Answer 2

Answer:

Data Consolidation

Explanation:

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.