The following is a sample of a worksheet in Excel. To complete this exercise, download the Excel

Question:

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.

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

Step by Step Answer:

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