u$.$ Panel

Excel $365$: Performing data analysis and forecasting in Excel $365$

Exit Test

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

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

Consolidate the data from the worksheets

$2.$

Go to the Data tab on the Ribbon

Navigate to the Consolidate window

$3.$

Configure the settings to consolidate the data

$4.$

$5.$