In this scenario, you need to prepare, consolidate, and analyze data that comes from different sources and in different formats. Perform the following actions:

$1.$ On the Duplicates sheet, prepare the data by removing duplicate rows. Use the appropriate command instead of performing the task manually.

$2.$ On the Consolidate sheet, find the average sales for Quarter $3$ and Quarter $4$ by product. Use the information in the Area $1$ Sales and Area $2$ Sales worksheets. Include the top row labels for the two quarters.

$3.$ On the Format sheet, remove the font formatting for the rule assigned to cells C$2$:C$28.$ Use the Regular Font style and Automatic $($instead of Red$)$ font color. Assign a new background fill color of your choice to the rule.

$4.$ On the Format sheet, format cells E$2$:E$28$ with the Red to Black icon set.

$5.$ On the Subtotal sheet, calculate the average units sold and average gross profit by Product. Hint: you may need to sort the data first.

$6.$ On the Analyze sheet, in cell B$6,$ use the appropriate formula to calculate the total Gross Revenue from the Data sheet based on the criteria provided in cells B$4$:D$4.$