if numbers do not match, pick the closest answer
ns it fd ith Requirements for the Excel analysis 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 (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. Retail stores - Total sales (Cell D3) $187,500.00 Total units (Cell B6) 17,500.00 Using the Excel file you created, what are the total sales? O A. $86,000.00 OB 17.500 OC. $381,500.00 OD. $108,000.00 Using the Excel file you created, what are the total unit sales from the Web distribution channels? O A 17.500 OB. 1.500 C. 2.500 D. 100V OC. 2,500 OD. 4,000 Using the Excel file you created, what are the total dollar sales from the Web distribution channels? O A. $50,000.00 OB. $36.000.00 OC. $381.500.00 D. 586.000.00 A. 7.500 B. 1.500 OC. 4.000 OD 6,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. $187.500.00 OB. $79.500.00 @ C. $14.000.00 D. $108,000.00 Sanchez Books Schedule of sales For the year ended December 31 E-Book children's E-Book fiction E-Book nonfiction Hardcover children's Hardcover fiction Hardcover nonfiction Paperback children's Paperback fiction Paperback nonfiction Total 105,500 236,000 155,500 98,000 110,000 85,500 210,000 330,000 420,000 Average Total E-Book sales Total Hardcover sales Total Paperback sales Total Children's sales Total Fiction sales Total Nonfiction sales ns it fd ith Requirements for the Excel analysis 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 (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. Retail stores - Total sales (Cell D3) $187,500.00 Total units (Cell B6) 17,500.00 Using the Excel file you created, what are the total sales? O A. $86,000.00 OB 17.500 OC. $381,500.00 OD. $108,000.00 Using the Excel file you created, what are the total unit sales from the Web distribution channels? O A 17.500 OB. 1.500 C. 2.500 D. 100V OC. 2,500 OD. 4,000 Using the Excel file you created, what are the total dollar sales from the Web distribution channels? O A. $50,000.00 OB. $36.000.00 OC. $381.500.00 D. 586.000.00 A. 7.500 B. 1.500 OC. 4.000 OD 6,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. $187.500.00 OB. $79.500.00 @ C. $14.000.00 D. $108,000.00 Sanchez Books Schedule of sales For the year ended December 31 E-Book children's E-Book fiction E-Book nonfiction Hardcover children's Hardcover fiction Hardcover nonfiction Paperback children's Paperback fiction Paperback nonfiction Total 105,500 236,000 155,500 98,000 110,000 85,500 210,000 330,000 420,000 Average Total E-Book sales Total Hardcover sales Total Paperback sales Total Children's sales Total Fiction sales Total Nonfiction sales
