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.

Transcribed Image Text:

B Year 1 1 Sales Revenue 2 Home party sales $ 261,048 $ 3 Company website $ 125,450 $ 4 Amazon.com $ 76,820 $ 5 6 Gross Profit 7 Home party sales $ 8 Company website $ 9 Amazon.com Ş 10 95,057 $ 50,180 $ 26,887 $ C Year 2 262,307 $ 134,307 $ 85,485 $ 94,870 $ 60,922 $ 29,646 $ D Year 3 264,406 $ 147,737 $ 96,701 $ 99,787 $ 62,892 $ 33,188 $ F E Year 4 Year 5 252,243 $ 262,408 $ 156,582 $ 152,022 112,318 136,512 $ 94,367 $ 66,890 $ 36,560 $ 92,510 $ 72,028 $ 41,363 $ G Year 6 260,729 $ 173,963 $ 168,728 $ 95,314 $ 83,537 $ 50,551 $ H Year 7 245,216 $ 179,008 $ 214,960 $ 91,833 $ 94,874 $ 47,764 $ Year 8 Sparkline 242,381 199,200 309,220 91,350 110,656 62,462