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

Which of the following functions adds cell values together and divides the result by the number of values? 1. MIN 2. MAX 3. AVERAGE 4. COUNT

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

What function will add up all the numbers in a column?*1 point=IF(A1:A6)=SUM(E1:E5)=AVERAGE(E1:E5)=CONCAT(E1:E5)

What function would you use to find the highest value in a range of cells?Answer areaMAX()SUM()MIN()AVG()

The _________ function takes all of the values in each of the specified cells and totals their values?Select one:A.SumB.AvgC.Total