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

Question:

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.

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

Step by Step Answer:

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