Which Excel function is used to find the largest value in a range of cells?a) =SUMb) =MAXc) SUMd) MAX

The Excel function of ________ is used to find the largest value in a range of cells.Group of answer choicesSUM(range)COUNT(range)MAX(range)COUNTIF(range, criteria)

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

What does the function =MAX(A1:A10) do? aFinds the minimum value in the range bAverages the values in the range cCounts the number of cells in the range dFinds the maximum value in the range

______ function is use to get maximum number of among series of data in excel.

Which one is not a function of Excel?SUMAVGMINMAXIf