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

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

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

Which of the following functions would you use to calculate the value of cell C18.(1)Group of answer choices=SUM=COUNT=COUNTIF=COUNTA

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

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