To answer this question, complete the lab using the information below.

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 C2:C28. 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 E2:E28 with the Red to Black icon set.
5. On the Subtotal sheet, add Subtotals to the data set that shows the average Units Sold and Gross Profit for each change in Product.
6. On the Analyze sheet, in cell B6, use the appropriate formula to calculate the total Gross Revenue from the Data sheet based on the criteria provided in cells B4:D4.