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)

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

e correct answer What is the average value of the following Python code snippet?>>>marks1 = 40>>>marks2 = 50>>>avg = (marks1 + marks2) / 2

POP QUIZ!Quiz: Intermediate Sheets Functions | Question 2Note: Make sure to put your answer in all capital letters (e.g. AVERAGE). Use functions from Google Sheets Functions 2023How would you easily summarize data to show the average sales per employee?

You want to be able to find the average price of Keyboards sold in your shop. You enter the function =AverageIfs (A1:A10, B1:B10, “<>Keyboard”). Assuming all the ranges are correct in this function, what will it return?0 / 1 pointIt returns the average of select values in columns A1:A10 and B1:B10 as long as their column Title is equal to “Keyboards.”It returns the average of a range of values if none of the values are empty.It returns the average of select values in A1:A10 given that the corresponding value in B1:B10 is not equal to “Keyboard.”It returns the average of select values in A1:A10 as long as the corresponding value in B1:B10 is a substring of or is equal to the word “Keyboard.”

Explain the functions used for Calculating the following for a Column in MS-Excel:  a)Averageb)Total b)Minimum c)Maximum[5]