Find the qty and average sales price to segun using the table below date product name sales qty discount profit 8/27/2019 Office Impressions End Table, 20-1/2"H x 24"W x 20"D 1488.424 7 0.3 -297.685 7/25/2018 Office Impressions End Table, 20-1/2"H x 24"W x 20"D 2430.08 8 0 388.8128 3/3/2018 Office Impressions End Table, 20-1/2"H x 24"W x 20"D 637.896 3 0.3 -127.579 10/23/2019 Office Impressions End Table, 20-1/2"H x 24"W x 20"D 637.896 3 0.3 -127.579 12/22/2019 Office Impressions End Table, 20-1/2"H x 24"W x 20"D 607.52 2 0 97.2032

33.3% complete  A B C D E F  Region Style Ship Date Units Price Cost1 East Tee 1/31/2018 12 11.04 6.422 East Golf 1/31/2018 12 13 7.253 East Fancy 1/31/2018 10 11.96 6.74 West Tee 1/31/2018 15 11.04 6.425 West Golf 1/31/2018 12 13 7.256 West Fancy 1/31/2018 10 11.96 6.7QuestionQ. In which section of the table would you find information about the retail sales price?A.Column E, Rows 3 through 6 onlyB.Column E, Rows 1 through 6C.Column F, Rows 1 through 6D.Column F, Rows 3 through 6 only

Sean used a function for the cells in the Qtr1 column. What did he enter in cell B7 in order to correctly calculate the average of Quarter 1 sales for Aanya, Charlie and Connor?1 point=AVERAGE(B4+B6)=AVG(B4:B6)=AVERAGE(B4:6)=AVERAGE(B4:B6)=AVERAGE(B4):AVERAGE(B6)

For a firm in a perfectly competitive market, average revenue equals ________.Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answer.athe market pricebaverage total costYour answercfixed costdprice divided by quantity

Required informationSkip to question[The following information applies to the questions displayed below.] The following data were provided by Mystery Incorporated for the year ended December 31: Cost of Goods Sold $ 170,000Income Tax Expense 19,230Merchandise Sales (gross revenue) for Cash 250,000Merchandise Sales (gross revenue) on Credit 44,000Office Expense 19,500Sales Returns and Allowances 7,350Salaries and Wages Expense 42,2002-a. What was the dollar amount of gross profit?2-b. What was the gross profit percentage? (Round your percentage to 1 decimal place.)

Problem StatementThe finance department wants to analyze the distribution of salaries across different departments. Write a query to calculate the average salary for each department and display the department name along with the average salary.Table details are given below:The table is created, and the records are already inserted at the backend. The sample records are given below.Note:Table names and Field Names are case-sensitiveInput format :The input records are already prepopulated, as given in the problem statement.Output format :The output displays the details of the average salary for each department as shown below.Department_name Average_SalaryEngineering 59000.000000Marketing 70000.000000