Question

Open the worksheet that contains the cell ranges to be consolidated​

Answer 1

Answer:

The worksheet is renamed 'Consolidated Summary'. Select the upper-left cell of the area where you want the consolidated data to appear. On the Ribbon, Choose Data > Consolidate to view the Consolidate dialog: In the Function box, click the summary function that you want Excel to use to consolidate the data.

$\\ \\ \\ \\ \sf \colorbox{lightgreen} {\red★ANSWER ᵇʸɴᴀᴡᴀʙ}$