What does the following formula in Excel calculate?=SUM(A1:A10) / COUNTIF(B1:B10, ">50")Answer areaThe sum of values in cells A1 to A10, divided by the count of values in cells B1 to B10 that are greater than 50.The count of values in cells A1 to A10, divided by the sum of values in cells B1 to B10 that are greater than 50.The average of values in cells A1 to A10, where the corresponding value in cells B1 to B10 is greater than 50.The sum of values in cells A1 to A10, where the corresponding value in cells B1 to B10 is greater than 50.

What will this spreadsheet function return? =SUMIF(H1:H50, ”>=50”, J1:J50)1 pointThe sum of all values in cells H1 to H50 for which the value in cells J1 to J50 is greater than or equal to 50.The sum of any values in cells H1 to H50and cells J1 to J50 that are greater than or equal to 50.The sum of all values in cells J1 to J50 that correspond to values in cells H1 to H50 that are greater than or equal to 50.The count of the number of cells in the array H1:H50 that have a value greater than or equal to 50.

Which function can be used to calculate the average of a range of values in Excel?Group of answer choicesSUMAVERAGECOUNTMAX

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

To add the values stored in a group of cells, and then divide it by the number of values, we can use the pre-defined function Question 2Answera.MINb.COUNTc.SUMd.MAXe.AVERAGE

What function can be used in Google Sheets to find the average of a range of numbers