The following is a sample of a worksheet in Excel.

To complete this exercise, download the Excel file from MyLab Accounting.

Requirements
Perform the following tasks in the Excel worksheet you downloaded from MyLab Accounting.

a. In Cell D2, multiply units times price.
b. Copy Cell D2 to cells D3 through D5.
c. In Cell B6, calculate the total number of units.
d. In Cell D6, calculate total sales.
e. In Cell B9, calculate total unit sales from Column B from the Web distribution channels.
f. In Cell B10, calculate total dollar sales from Column D from the Web distribution channels.
g. In Cell B11, calculate 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:

A Distribution channel 1 2 Web sales: Company website 3 Retail stores 4 Web sales: Amazon.com 5 Wholesale clubs Total 6 7 8 Details for Web sales: 9 Total Web sales in units Total Web sales in dollars 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 150 $ 850 $ 300 $ 700 $ с Price 2.00 3.00 2.50 1.75 D Total sales