The steps you will follow for this project are as follows: 1) Download the Excel data file. 2) Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step-by-step. 3) Perform the requirements on the data file. 4) Check your work in the Excel file with these check figures. 5) Use your Excel file to answer the six multiple choice questions below. (You will have to scroll down to see all of the questions.) Resources A) Information on how to update Excel and Office 365 . B) If you do not have Office 365 , click here to learn how to get it for free. C) Troubleshooting FAQ. This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the Excel file you created, what are the total sales? A. 4,700 B. $10,410.00 C 22 ann nn The steps you will follow for this project are as follows: C. $3,600.00 D. $1,560.00 Using the Excel file you created, what are the total unit sales from the Web distribution channels? A. 2,000 B. 4,700 C. 1,200 D. 800 Using the Excel file you created, what are the total dollar sales from the Web distribution channels? A. $10,410.00 B. $1,200.00 C. $2,400.00 D. $3,600.00 Usina the Excel file vou created. what are the average Web sales per unit? The steps you will follow for this project are as follows: A. $1.80 B. $2.00 C. $2.21 D. $1.50 Using the Excel file you created, what is the difference between the retail store units and the wholesale club units? A. 1,500 B. 1,200 C. 300 D. 2,000 Using the Excel file you created, what is the difference between the retail store total sales dollars and the wholesale club total sales dollar A. $3,690.00 B. $1,200.00 C. $1,560.00 C. $2.21 D. $1.50 Using the Excel file you created, what is the difference between the retail store units and the wholesale club units? A. 1,500 B. 1,200 C. 300 D. 2,000 Using the Excel file you created, what is the difference between the retail store total sales dollars and the wholesale club total sales dollars? A. $3,690.00 B. $1,200.00 C. $1,560.00 D. $5,250.00 The steps you will follow for this project are as 1) Download the Excel data file. Requirements for the Excel analysis 2) Click on the Video button on the bottom I a. In Cell D2, multiply units times price. exercise, step-by-step. b. Copy Cell D2 to cells D3 through D5. 3) Perform the requirements on the data file c. In Cell B6, calculate the total number of units. 4) Check your work in the Excel file with the d. In Cell D6, calculate total sales. 5) Use your Excel file to answer the six mul e. In Cell B9, calculate total unit sales from Column B from the Web distribution channels. Resources 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 (Hint: total Web sales in dollars divided by total Web sales in units). 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