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

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

Which SQL function is used to find the highest value in a column?OptionsMAX()AVG()MIN()SUM()

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

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)

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