Question

Varun has got marks of 500 students of Term 1 and Term 2 of class X in separate sheets. He needs to create a third sheet that contains total of Term 1 and Term 2 of all the students. Which of the following option is best suited for this?

Goal Seek
Sheet Linking
Data Consolidation
Scenario​

Answer 1

Answer:

Mark me brain list plz bro this answer is 2

Answer 2

Data Consolidation.

Explanation:

Data Consolidation allows one 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 combines it into a single worksheet that one can update easily.

Steps:

1. Open the two source sheet.

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

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.