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.”

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 costcfixed costdprice divided by quantity

If cell range A1:A3 contains the numbers 5, 6 and 7, then =AVERAGE(A1:A3, 10)  will return __________*1 point671.818

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?

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

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)