Question

which of these button is used to include the selected range of cells in the concolidation range this text box​

Answer 1

Answer:

In the Reference box select the first cell range you want to use in the consolidation, in this case "C3:F5". You can type the cell range in directly but make sure prefix it with the name of the worksheet enclosed in single quotes. Press the Add button to add this range to the "All references" list.

Explanation:

I hope you☺ understand dear