Following is a screenshot of a worksheet in Excel. In this exercise, Excel for Windows is being used.

Requirements
List the formula that would be entered in the specified cells in the Excel worksheet.
a. Cell D2: Units times Price
b. How would cell D2 be copied to cells D3 through D5?
c. Cell B6: Total number of units
d. Cell D6: Total sales
e. Cell B9: Total unit sales from Column B from the Web distribution channels.
f. Cell B10: Total dollar sales from Column D from the Web distribution channels.
g. Cell B11: Average Web sales per unit
h. Cell B14: Difference between the retail store units and the wholesale club units.
i. Cell B15: Difference between retail store total sales dollars and wholesale club total sales dollars.

Transcribed Image Text:

1 Distribution channel 2 Web sales: Company website 3 Retail stores 4 Web sales: Amazon.com 5 Wholesale clubs 6 Total 7 8 Details for Web sales: Total Web sales in units Total Web sales in dollars 9 10 11 Average Web sales per unit 12 13 Retail compared to Wholesale: 14 Difference in units 15 Difference in total sales dollars B Units 100 $ 800 $ 200 $ 600 $ Price 1.80 2.50 2.00 1.50 Total sales