Question

Shanaya is doing a survey based on the number of educated girl children in the major

states of India for the years 2006, 2011, and 2016 for which she has created a

spreadsheet. Now, she wants to calculate the total number of educated girl children in

these states year-wise in another sheet. How can she do this?

a) By sharing the sheets b) By consolidating the sheets

c) By merging the sheets d) By linking the sheets ki​

Answer 1

Explanation:

c) By merging the sheets is the answer mate.

Answer 2

Answer:

c) my merging the sheet.

Explanation:

Steps of merging sheets:

For consolidation by position to work, each source sheet's data range must be in list format and the list must not have blank rows or blank columns.

• Open each source sheet and verify that the data is in the same location on each sheet.
• On the target sheet, click the upper left cell in the area where you want the consolidated data to appear.
• Click consolidate on data tools.
• In the Function box, click the function you want Excel to use to consolidate the data.
• On each source sheet, select the data.
• All references have file paths entered.
• After adding data from each source sheet and workbook, click OK.

#SPJ2