Question

In the Combined Sales worksheet, add a new column with the title % Total between the % Change and Sales columns.

Answer 1

To add a % Total column in the Combined Sales worksheet, open the Excel file, locate the worksheet, insert a new column between the % Change and Sales columns, and title it as % Total.

Step-by-step explanation:

1. Open the downloaded Excel file.
2. Locate the Combined Sales worksheet.
3. Insert a new column between the % Change and Sales columns.
4. Title this new column as % Total.

The addition of the % Total column will allow you to display the percentage of total sales represented by each value in the Sales column. This can be helpful in analyzing the relative contribution of each sales figure.