Margolin Home Products currently sells its products through multiple distribution channels. When the company first started, its

Question:

Margolin Home Products currently sells its products through multiple distribution channels. When the company first started, its home cleaning products were sold strictly through home party sales. About 15 years ago, the company set up a website and sold its products through its own website. It also sells its products on Amazon.com. Annual sales and gross profit data from the past eight years is shown in the following screenshot of an Excel worksheet that a company manager prepared.

Using the screenshot, answer the following questions:
1. What is the Excel feature that is pictured in Column J?
2. Describe the steps that would have been taken in Excel to display the line contained in Cell J2.
3. Which distribution channel(s) is trending upward in sales revenue over the time period pictured?
4. Which distribution channel(s) is trending upward in gross profit over the time period pictured?
5. Describe a feature in Excel that might be used to create a larger visual depiction of the trends in sales revenue by distribution channel.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: