Question: Sequence the steps to consolidate data. As the first step, you've set up data in several worksheets and selected where th consolidated data should appear in the master worksheet in Excel $365.$

Match the options and taigets that relate to one another and then select Done.

Open the Consolidate window

$2.$

Switch to the Data tab on the Ribbon

$3.$

Select the consolidation settings

Consolidate the worksheet data

$4.$

$5.$