Question

Anant is working as teacher in a school. He saves/store marks of his students

of each exam in different sheets. Which of the following option will help him to

gather data from different sheets to one sheet.

a. Subtotal

b. Consolidate

c. Goal Seek

d. Scenario​

Answer 1

Answer:

c goal seek is the answer

Answer 2

Consolidate

Explanation:

1. Open each source sheet.

2.  In the destination sheet, click the upper-left cell of the area where one wants the consolidated data to appear.

3. On the Data tab, in the Data Tools group, click Consolidate.

4. In the Function box, click the function that one want Excel to use to consolidate the data.

Data Consolidation allows one to gather together their 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 summarises it into a single worksheet that one can update easily.